Is it possible to automate the backup activities without my interactiongreenspun.com : LUSENET : SQL Server Database Administration : One Thread |
Hello Sir, Is there any way to auotmate my backup activities. Like i have to take particular database thrice in a day. with out my manual interaction can i automate this job of backups. Regards, Raja V
-- Anonymous, April 17, 2003
Raja,In SQL Enterprise Manager, expand the Management folder, right click on Database Maintenance Plans, select New Maintenance Plan..., click Next, click in the checkbox by the database you want to schedule backups for, click Next 3 more times, and you will now be at the Specify Database Backup Plan screen.
Hope this helps,
Eric
-- Anonymous, April 19, 2003