Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kensai
Posting Yak Master
172 Posts |
 Posted - 2012-01-02 : 06:06:58
|
| Is it possible to make backups of maintenance plans? We have a maintenance plan which I'd like to be able to easily move when we change the server. I didn't see any "script as.." options on it.. |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2012-01-02 : 10:57:41
|
| Open BIDS - create a new Integration Services project. Right-click in the Solution Explorer on Packages and Add Existing Item. When the dialog box comes up, select the server you want to pull the maintenance plans from and add the items to your project.Once you have this project built, you can then modify the connection information and Save Copy As to a new server. If you don't change the connection information, SQL Server will actually run that maintenance plan on the old server.Once the package has been copied to the other server - you then have to modify the packages in SSMS to select the right databases and create the schedule.Jeff |
 |
|
|
kensai
Posting Yak Master
172 Posts |
Posted - 2012-01-03 : 04:29:31
|
| Thank you Jeff. |
|
|
|
|
|
|
Make backups of maintenance plans