Post reply

Maintenance Plan Template??? (Copying from one server to another.)

  • December 4, 2006 at 2:06 pm

    #115198

    I've created a 2005 Maintenance Plan that I'd like to re-create on all current and future SQL 2005 installations that I have.  Is there a way to "export" the plan so I can "import" it into a new server?

  • December 4, 2006 at 2:56 pm

    #675639

    You can create a Maint. Plan in BIDS and then deploy as any other SSIS package to all your boxes. You can then create a job to schedule to your liking. It may not be exactly what your looking for.. but it works

    Thanks,

    Rich

  • December 6, 2006 at 3:22 am

    #676159

    try writing the steps your self in a job. You can then simply script the joob to another server.

  • December 6, 2006 at 10:46 am

    #676337

    Maintenace plans are easy to created but in 2005 there are some issue to be addressed..

    You can write a script for backup, reindexing and dbcc checkdb ect.... You can create a job and you can migrate to any server and you will have more control to modify them..

     

    MohammedU
    Microsoft SQL Server MVP

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply