![]() ![]() ![]() Right-click each maintenance plan that you want to migrate, and then click Migrate.In Object Explorer, expand Management, expand Legacy, and then expand Database Maintenance Plans.Start SQL Server Management Studio, and then connect to the affected instance of SQL Server.To use SQL Server Management Studio to upgrade maintenance plans, follow these steps: If all older maintenance plans are upgraded, Method 2 is not required. This method migrates maintenance plans to the SQL Server 2008 format. Method 1: Upgrade maintenance plans to the SQL Server 2008 or SQL Server 2008 R2 format (recommended) To resolve this problem, use one of the following methods. ![]() SQL Server Distributed Management Objects (SQL-DMO) For more information, see Discontinued Database Engine Functionality in SQL Server 2012. In SQL Server 2012 or a later version, SQL DMO is one of the discontinued features and customers are advised to use SQL Server Management Objects (SMO). This problem may occur if the SQL Server Distributed Management Objects (SQL-DMO) version that is installed cannot connect to an instance of SQL Server 2008 or SQL Server 2008 R2. This issue also occurs in SQL Server 2012 Cause ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |