Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    26

    Unanswered: Scheduling MSSQL Databases Daily Backup

    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 Regards

  2. #2
    Join Date
    May 2003
    Location
    Rochester, NY
    Posts
    135

    Re: Scheduling MSSQL Databases Daily Backup

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

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •