Upgrading sql server 2000 to sql server 2005, Moving sql servers between domains – Dell PowerVault DP600 User Manual
Page 64
64
In This Section
Upgrading SQL Server 2000 to SQL Server 2005
Moving SQL Servers Between Domains
How to Rename a Computer Running SQL Server
Changing the Recovery Model of a Database
Replacing a Disk on a SQL Server
Adding Databases to a SQL Server
Changing the Path of a SQL Server Database
Renaming a SQL Server Database
Upgrading SQL Server 2000 to SQL Server 2005
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.
Moving SQL Servers Between Domains
You cannot do the following for protected computers:
• Change the domain of a protected computer and continue protection without disruption.
• Change the domain of a protected computer and associate the existing replicas and recovery
points with the computer when it is re-protected.
We recommend that you do not change the domain of a protected computer. If you must change
the domain of a protected computer, you must complete two tasks:
• Remove the data sources on the computer from protection while the computer retains its
original domain membership.
• Protect the data source on the computer after it becomes a member of another domain.