Is it possible to automate the backup activities without my interaction

greenspun.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

Answers

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


Moderation questions? read the FAQ