I'm following the steps listed in the wiki to backup the database but every time I try to run Backup I get Access denied errors. I am running Vista and using my administrator account.
Any suggestions?
Can't backup database?
Débuté par
PavelNovotny
, déc. 11 2009 12:26
Retour en haut
#2
Posté 11 décembre 2009 - 12:34
BryanDerksen
-
- BioWare Employees
-
- 273 messages
Oh MSSQL, you cause such pain...
I'm not as experienced with troubleshooting database issues as Allan is, but my first suggestions would be to try changing the directory where the backup is being written to (set in config.ini), perhaps to someplace nice and simple like C:\\ as a temporary measure. Also perhaps try running the batch file explicitly in administrator mode (right-click and select "run as administrator").
I'm not as experienced with troubleshooting database issues as Allan is, but my first suggestions would be to try changing the directory where the backup is being written to (set in config.ini), perhaps to someplace nice and simple like C:\\ as a temporary measure. Also perhaps try running the batch file explicitly in administrator mode (right-click and select "run as administrator").
#3
Posté 11 décembre 2009 - 12:54
BryanDerksen
-
- BioWare Employees
-
- 273 messages
Weird. It could be that the directory the backup batch file is in is restricted in some way I'm not familiar with. We use Windows XP for development internally, in part because of the annoyance of these sorts of Vista shenanigans. 
Perhaps try copying the backup/restore directory somewhere else where Vista might not be so paranoid about letting you run or edit stuff?
Alternately, you can try running the SQL commands directly from the command line instead. The batch files really only exist to wrap a single SQL command in a convenient-to-run package.
http://social.biowar...kup_and_restore has the commands you'll need to do this. If it doesn't work, either check to ensure that sqlcmd.exe is in your path or run the command from the directory that sqlcmd.exe is in.
Perhaps try copying the backup/restore directory somewhere else where Vista might not be so paranoid about letting you run or edit stuff?
Alternately, you can try running the SQL commands directly from the command line instead. The batch files really only exist to wrap a single SQL command in a convenient-to-run package.
http://social.biowar...kup_and_restore has the commands you'll need to do this. If it doesn't work, either check to ensure that sqlcmd.exe is in your path or run the command from the directory that sqlcmd.exe is in.
#4
Posté 12 décembre 2009 - 12:19
BryanDerksen
-
- BioWare Employees
-
- 273 messages
Glad to see you were able to work through that. Once the obvious ideas were eliminated earlier in the thread, I'm afraid I was reduced to just sitting in the corner mumbling about Vista and MSSQL in my usual mixture of whimpering rage. I'll add "try the 2008 version" to my repertoire of suggestions.
