What's the Proper Way to Backup MSDE Database

[DoctorDos]

I need to backup an MSDE database using Arcserve 2000. Does anybody know the best way to accomplish this? Will the Backup Agent for SQL work? Or Open file agent? Something that will backup the database when it's still being used is what I'm looking for.

Thanks

 

[gwichman]

One would think it would since MSDE is based on MSSQL 2000 however it could also be disabled somehow either by MS or CA so ultimately you'll have to get the info from CA as to whether their backup agent works with it or not.

If it doesn't your only other option will probably be to do a backup to disk and then backup those files with a normal backup agent - if that functionality is supports by MSDE (backing up to disk directly).

If thats not supported either you're dead and will need to shutdown MSDE to back it up. It could be scripted and run at a certain hour though so not all is lost perhaps.. depends on your requirements.

 

[ACiDelic]

The SQL agent can be used to backup MSDE. I have done this in the past and it worked fine.

 

[DoctorDos]

Thanks for the information! Exactly what I needed to know.