Backup and Restore Procedure Implementation 1

[madjakers]

Is there a way to automate the backup procedure of my SQL databases without manually shutting them down, backing them up, and then starting them back up again?

Thanks, Jake

 

[madjakers]

I am running a Win 2000 Server environment

 

[ecobb]

I'm not sure if I understand you correctly, but if you're asking how to schedule backups, you can do it in Enterprise Manager. Just click on the "management" folder and right click on "Database Maintenance Plans". This will take you through a wizard that will set up and schedule backups of the database and/or transaction logs as often as you would like.

Hope this helps!

 

[fluteplr]

I case it was not clear from the above response. If you use sql server to back itself up, it does not need to be shut down. It can backup databases while they are being used.

 

[madjakers]

Thanks for the help!