Managing protected servers running sql server – Dell PowerVault DP600 User Manual
Page 61
61
If the database or logs on the passive node are corrupt, use either of the following procedures to
recover data.
To recover from failure on the passive node
1. On the Exchange server, in Exchange Management Shell, run suspend-
storagegroupcopy for the failed storage group.
2. Delete all .logs, .chk, and .edb files from the copy location (passive node).
3. In the DPM Recovery Wizard, copy the database files without running database clean
shutdown to the passive node.
4. Move the files to appropriate locations in the passive node.
5. Remove the common log files (between active and passive nodes) from the passive
node. For example, a failover might have created a new log stream with the same log file
names.
6. On the Exchange server, in Exchange Management Shell, run resume-
storagegroupcopy for the failed storage group.
To recover from failure on the passive node (if both copies are corrupt)
1. Set the Exchange Server database property Override by restore to True.
2. In the DPM Recovery Wizard, recover to the active node.
3. On the Exchange server, in Exchange Management Shell, run get-
storagegroupcopystatus to verify the copy status.
4. After recovery, synchronize the passive nodes with the active node.
See Also
Managing Clustered Exchange Servers
Managing Protected Servers Running SQL
Server
This content applies to both Microsoft® SQL Server 2000 and SQL Server 2005, unless
otherwise specified.
In This Section
Performing General Maintenance on Servers Running SQL
Performing SQL Server Management Tasks