Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
When you delete maintenance plans on a server instance that is restored from a SQL Server 2008 MSDB database backup, maintenance plans are deleted from the server instance on which the MSDB database was backed up
Article ID: 955800 - View products that this article applies to.
Consider the following scenario:
When you delete a maintenance plan from SQL Server, SQL Server Management Studio uses the connection information that is available in the maintenance plan of the SQL Server 2008 Integration Services (SSIS) package. In this scenario, this connection points to Instance A. Therefore, maintenance plans are deleted from Instance A.
Article ID: 955800 - Last Review: September 15, 2009 - Revision: 3.0