Upgrading SQL Server 2000 to SQL Server 2005

  • Article

Applies To: System Center 2012 - Data Protection Manager, System Center 2012 R2 Data Protection Manager, System Center 2012 SP1 - Data Protection Manager

If you upgrade a protected server running SQL Server 2000 to SQL Server 2005, you must reprotect the databases after the upgrade by performing the following steps:

  1. Stop protection of the databases, choosing the retain data option.

  2. Start the SQL Writer Service on the upgraded server.

  3. Add the databases on the upgraded server to a new protection group.

You will be able to use the retained replica to recover data from points in time before the upgrade. Data created by SQL Server 2000 must be restored to a computer running SQL Server 2000.

You can also use the retained replica to manually create the initial replica for each database in the new protection group.

Note

After you reconfigure protection, DPM Administrator Console displays the protected database as two separate nodes. The protection status in the Protection task area appears as Inactive replica for one of the database nodes, and the Recovery task area displays two database nodes with the same name.

-----
For additional resources, see Information and Support for System Center 2012.

Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.
-----