Hi -
I want to Schedule Daily Backup of MSSQL Databases .. How can i do it .. How can i schedule it so that it get backuped everyday automatically at desired time.
Kind RegardsYou need to read up on Maintenance Plans on BOL. How yoyur databases are setup and each applications recovery requirements in order to setup the backups properly. Also read up on Recovery Plans.|||You can use the SQL Server Agent Utility (available through Enterprise Manager) to schedule jobs to run at regular times. The Maintenance Plan wizard merely creates the jobs for you (and also provides a convenient method of grouping databases upon which to perform identical maintenance).
blindman
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment