View Single Post
Old 2008-04-29, 16:43   #2 (permalink)
Marcusb
Super Moderator
 
Join Date: Feb 2005
Location: Melbourne
Posts: 1,869
Thanks: 55
Thanked 24 Times in 24 Posts

Country:

My System

Send a message via ICQ to Marcusb
Default

OK, I made a batch file that should back up the MP database using an OSQL command line query.
Just set it to run via a sceduled task once a day and it will back up the database and manage the last five days worth of backups.

It's pretty quick and dirty and needs some setting up.
I'm not home at the moment, so can't test it, but in theory it should work.
I'll fly home tomorrow so should be able to test it myself and post the matching restore files too (home is a long way away).

Basically just open the attsached file and make sure you change the file location variables to match what you have and create any required sub folders.
Then change the file name extension from txt to bat (since the forum wont allow me to upload batch files.

I'll be out of contact for the next day or two, then can make any tweaks as needed. I tested it with a different SQL express database that I have here and it works well, so any issues may just be with the database name, password or file structure, since I'm going from memory.

Also, I know I should use "IfExist" before copying or deleting files, but like I said, it's quick and dirty

Cheers,
Marcus.
Attached Files
File Type: txt MP_database_backup.txt (1.8 KB, 15 views)
Marcusb is offline   Reply With Quote