Results 1 to 3 of 3

Thread: backup planning

  1. #1
    Join Date
    Jul 2003
    Location
    France
    Posts
    3

    Unhappy Unanswered: backup planning

    following the installation of Ms SQL server 2000, the backup planning is not saved. Have hou got an idea?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    If your backups are scheduled as SQLServer Agent Jobs, they can be scripted out and then run against your new database.
    I don't think you can script the maintenance plans, but a little-known fact is that they aren't anything more than glorified Wizards that create the SQLServer Agent Jobs. After this, they serve only to define what databases the job should apply to.
    See Books Online for the xp_sqlmaint procedure for more details. This is the procedure that the jobs use, and you can use it yourself without going through the maintenance plan wizard.

    blindman

  3. #3
    Join Date
    Jul 2003
    Location
    France
    Posts
    3


    Thank you,
    I'm going to search with this

Posting Permissions

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