Database Backup & Restore (1 Viewer)

[kingnubian]

I would love a simple database backup & restore tool which can backup individual or all databases either through a scheduler or manually. This can be done while in MP via the remote control.

 

[Marcusb]

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.

 

[DranDane]

I think it's better to use the intagrated backup system of SQL server or MySQL. It's not a priority for me.

 

[Marcusb]

the thing is that SQL express doesn't have any method to automate backups.
if you want a nightly back up or something similar then you need some type of script to run as a sceduled task.

 

[MoPhat]

Hi, you can take the one BAT file and the other SQL file the enable scheduled SQL database backups.

Just change the path, username, password and the pc name on both files.

After this you can add backup.bat to the windows scheduler to auomate backups

greetz
MoPhat