Recovery Using SQL Server Database Mirroring: Moving CommCell Operations to the Production CommServe Host
Caution: SQL database mirroring is deprecated by Microsoft and may not be available in future versions of Microsoft SQL Server. Therefore, we recommend that you build the CommServe Disaster Recovery Using CommServe LiveSync For High Availability Disaster Recovery.
In a mirrored setup, when the production CommServe is unusable or inaccessible, the standby CommServe serves as a production CommServe for a few days or weeks. After you rebuild the original production CommServe, you can switch the CommCell operations back to the production CommServe host.
The process flow for moving CommCell operations back to the production CommServe host involves the following tasks in the order listed:
- Make sure there are no Commvault Services running on the production CommServe host. See Stopping a Service.
- If the SQL services on the production CommServe host are down due to a disaster, and the mirroring between production and standby CommServe databases is broken, then re-establish the mirroring relationship using SQL Management Studio software. Consult Microsoft manual for instructions on resuming database mirroring.
- Initiate a manual failover to production CommServe host using the following SQL query. Consult Microsoft manual for instructions on executing SQL queries.
ALTER DATABASE CommServ SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS
- Update the CommServe database with the host name of the production CommServe host using the CSRecoveryAssistant.exe.
See Recovering the CommServe Database for step-by-step instructions.
- Start the CommCell services on the production CommServe host. See Starting a Service.
- Open the CommCell console and verify that all the components, such clients, MediaAgents, Libraries, policies on the production CommServe are available.
- Using DNS, configure the host name of the old CommServe computer to point to the IP address of the new computer.
If you do not use DNS, contact customer support for assistance.
Important: Verify that all client computers point to the host name of the old CommServe computer, and not to the IP address. For instructions on changing the CommServe name on clients, see Changing the Client Computer Name.
- Perform a few backup and restore operations for any client to ensure that the production CommServe database is ready to perform all the CommCell operations.
Note: If there are inconsistencies between the DDB and the CommServe database during a backup or auxiliary copy operation, the DDBs are put in maintenance mode and an appropriate event message is displayed in the Event Viewer window. In such cases, run DDB Resynchronization to bring the DDBs online and revert it to a reusable state from the maintenance mode. See Resynchronizing the Deduplication Database.
- CommServe Recovery Using SQL Server Database Mirroring
- Building the Standby CommServe Host
- Moving CommCell Operations to the Standby CommServe Host
- Resynchronizing the Deduplication Database
Last modified: 2/6/2020 8:50:25 PM