Failback from SnapCenter Plug-in for SQL Server secondary storage to primary storage

Contributors netapp-soumikd

After the SnapCenter Plug-in for SQL Server primary storage is back online, you should failback to the primary storage.

What you will need

  • Place the SnapCenter Plug-in for SQL Server in Maintenance mode from the Managed Hosts page.

  • Disconnect the secondary storage from the host and connect from the primary storage.

  • To failback to the primary storage, ensure that the relationship direction remains the same as it was before the failover by performing the reverse resync operation.

    To retain the roles of primary and secondary storage after the reverse resync operation, perform the reverse resync operation once again.

  • Restart MSSQL server service.

  • Ensure that the SQL resources are back online.

Steps

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

  2. Unselect Enable Disaster Recovery.

  3. Click Apply.

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

After you finish

  • 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-SmDRFailoverBackups