............ Have a nice day............
✿ USER MENU ID IS UNDEFINED IN FINACLE MIS SERVER  ✿ Date of Implementation of "VERY GOOD" Bench Mark for MACPs effect from 25.07.2016  ✿ Expected DA from Jan 2017 – 3% or 2% ?   ✿ One minute talk time for each Rupee in Airtel Payments Bank  ✿ AICPIN for October 2016 : Chances for 5% DA from January 2017  ✿ Central Government employees retiring from January 2017 to submit online application  ✿ Pre-Budget Views of Govt. Employees for inclusion in the Budget for the Year 2017-18: Confederation i.e. Scrap NPS, Minimum Wage Rs. 26,000 & Fitment Formula etc  ✿ On Salary Week, Banks Unlikely to Meet Demand for Extra 1 Lakh Cr  ✿ 82 per cent ATMs dry because government used that money to pay its own employees  ✿ National Anthem Before Movie, Rules Supreme Court. Citizens 'Duty-Bound' To Show Respect    undefined

Saturday, 4 May 2013

How to: Migrate SQL Server 2000 Database Maintenance Plans to SQL SERVER 2005 or later versions


SQL Server 2000 database maintenance plans were Transact-SQL commands run by SQL Server Agent jobs. In SQL Server 2005 or later versions, maintenance plans are created as SSIS packages, which are also run by SQL Server Agent jobs. After upgrading SQL Server 2000 to SQL Server 2005 or later, the SQL Server 2000 database maintenance plans are visible under the Legacy node of the Management folder in Object Explorer. These database maintenance plans continue to work as they did before upgrading. You can maintain these database maintenance plans by right-clicking a plan and then clickingProperties.
To migrate the SQL Server 2000 database maintenance plans to the SQL Server 2005 or later version, right-click the database maintenance plan, and then click Migrate. To migrate database maintenance plans, you must be a member of the sysadmin fixed server role.

To migrate SQL Server 2000 database maintenance plans

  1. In Object Explorer, expand a server, expand Management, expand Legacy, and then expand Database Maintenance Plans.
  2. Right-click a database maintenance plan, and click Migrate.
  3. When the migration finishes, a SQL Server 2005 or later version of the plan is placed in the Maintenance Plans folder. Note that the SQL Server 2000 version of the plan remains in the Legacy folder and is still enabled.
  4. Test the migrated plan in the Maintenance Plans folder before you enable it, and then delete the SQL Server 2000 plan in the Legacy folder.
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)