Upgrading SQL Server 2000 to SQL Server 2005

  • Article

Applies To: System Center Data Protection Manager 2010

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.