Storage disaster recovery (DR) for SnapCenter Plug-in for SQL Server

Contributors netapp-nsriram netapp-soumikd

You can recover the SnapCenter Plug-in for SQL Server storage by enabling the DR Mode for Storage in the Global Settings page.

What you will need

  • Ensure that the plug-ins are in maintenance mode.

  • Break the SnapMirror/SnapVault relationship. Breaking SnapMirror relationships

  • Attach the LUN from secondary to the host machine with same drive letter.

  • Ensure that all the disks are connected using the same drive letters that were used prior to DR.

  • Restart MSSQL server service.

  • Ensure that the SQL resources are back online.

About this task

Disaster recovery (DR) is not supported on VMDK and RDM configurations.

Steps

  1. In the Settings page, navigate to Settings > Global Settings > Disaster Recovery.

  2. Select Enable Disaster Recovery.

  3. Click Apply.

  4. Verify whether the DR job is enabled or not by clicking Monitor > Jobs.

After you finish

  • If new databases are created after the failover, the databases will be in non-DR mode.

    The new databases will continue to operate like they did before the failover.

  • The new backups that were created in DR mode will be listed under SnapMirror or SnapVault (secondary) in the Topology page.

    An "i" icon is displayed next to the new backups to indicate that these backups were created during DR mode.

  • You can delete the SnapCenter Plug-in for SQL Server backups that were created during failover either by using the UI or the following cmdlet: Remove-SmBackup

  • After failover, if you want some of the resources to be in non-DR mode, use the following cmdlet: Remove-SmResourceDRMode

    For more information refer to the SnapCenter Software Cmdlet Reference Guide.

  • SnapCenter Server will manage the individual storage resources(SQL databases) that are in DR or non-DR mode but not the resource group with storage resources that are in DR mode or non-DR mode.