7 réponses à ce sujet

[Beerfish]

I was able to do this as instructed with my desktop pc and windows xp.  However I'm having problems with Vista on my lap top.  My config file is set up the way I want.  I right click on the Backup batch file and 'run as administrator' it give me a message that it cannot find the config file and produces no backup when I type 'Backup'

I noticed a paragraph at the bottom of the toolset wiki page concerning these batch files that reads as follows.  Should I be following the instructions below?  (Is there any on going problem with making the directory change as instructed below?)

Quick Backup & Restore
Before doing this tutorial I am going to assume you installed the toolset and sql server at the default settings.
Tutorial
1. create a folder called "Backups" in your C Drive.
2. navigate to the folder and make note of the files there.

C:\\Program Files (x86)\\Dragon Age\\tools\\DatabaseUtilities\\Backup_Restore

3. go to start --> programs --> accessories --> and "right
click" on "command prompt" then choose "Run as administrator"
4. A new window will come up and you'll notice in the top left it
will say administrator and you should be at the windows\\system32
directory
5. change directory to the backup_restore folder above.
6. run the backup.bat file and then type Backup to confirm ....
This will backup your entire DA database to the backups folder. The
file was around 783mb for me.

[DarthParametric]

You'll have to set the actual command prompt/dos box to run with elevated privileges (not the batch file), which is what the instructions specify.

[Proleric]

DAToolChest is easier (and provides other invaluable builder utilities).

[Beerfish]

DarthParametric wrote...

You'll have to set the actual command prompt/dos box to run with elevated privileges (not the batch file), which is what the instructions specify.

As in the instructions that I quoted at the end of my initial post?

[DarthParametric]

Yes. It says to run the command prompt as an administrator. Do that then run the batch file from there. Just tested it on Win 7 x64 and it worked fine.

+=================================================================+ 
+=================================================================+ 
Backup Batch File initated on 16/02/11 at  2:26:23.62
using the following config.ini settings: 
         ------------------------------------------- 
         Backup/Restore Config file 
         [SQL Server Name] 
         .\\BWDATOOLSET 
         [Database Name] 
         bw_dragonage_content 
         [Path to Directory to Save new Backup files to] 
         E:\\Dragon Age\\tools\\DatabaseUtilities\\BACKUP\\ 
         [Name of New Backup File] 
         DABackup001.bak 
         [Path to Directory Containing Existing Backup Files] 
         E:\\Dragon Age\\tools\\DatabaseUtilities\\BACKUP\\ 
         [Name of Existing Backup File to Restore] 
         DABackup001.bak 
         ------------------------------------------- 
 
Following command line being executed: 
sqlcmd -S .\\BWDATOOLSET -E -Q "BACKUP DATABASE bw_dragonage_content TO DISK = 'E:\\Dragon Age\\tools\\DatabaseUtilities\\BACKUP\\DABackup001.bak'" 
 
Processed 89808 pages for database 'bw_dragonage_content', file 'bw_dragonage_content' on file 1.
Processed 2 pages for database 'bw_dragonage_content', file 'bw_dragonage_content_log' on file 1.
BACKUP DATABASE successfully processed 89810 pages in 18.710 seconds (39.322 MB/sec).
 
Backup file will be found at: E:\\Dragon Age\\tools\\DatabaseUtilities\\BACKUP\\DABackup001.bak 
 
Batch File completed at  2:27:04.60 
+=================================================================+ 
+=================================================================+ 

Modifié par DarthParametric, 15 février 2011 - 04:30 .

[Eshme]

Yea point 3 is what needs to be done. (i got no vista cannot prove it, xp no makes trouble )

[Beerfish]

I had no question about running the command as the administrator but more so changing the directory. It's been so long that I have fiddled with anything dos like, do I still use this kind of syntax?



cd C:\\Program Files (x86)\\Dragon Age\\tools\\DatabaseUtilities\\Backup_Restore



(and the fact that this forum software to this day inserts extra back slashes is a travesty)

[DarthParametric]

Yeah, that's fine. Still uses all the old DOS syntax.