Skip to main content
SnapCenter software

Restore and recover SQL Server databases

Contributors netapp-soumikd
PDFs

You can use SnapCenter to restore SQL Server databases. Restoring a database is a multiphase process that copies all the data and log pages from a specified SQL Server backup to a specified database.

Before you begin

  • Configure the target instance with an active directory user who belongs to the SMB ADactive directory domain and has permissions to set the file permissions appropriately.

  • Configure the credentials at SnapCenter instance level.

  • If the SQL database exists on CIFS share, then the RunAS account and SQL service account (domain account) of the plug-in host need to be part of the BUILTIN\Administrators group of the CIFS server in ONTAP.

  • SMB configurations do not support SQL authentication for the target instance. Configure the target instance in SnapCenter with an active directory user who has the required permissions.

  • If the SnapCenter Plug-in service account is not an active directory user, ensure that a user with full control over the source volumes is available when restoring to an alternate host.

Steps

  1. In the left navigation pane, click Resources, and then select the appropriate plug-in from the list.

  2. In the Resources page, select either Database or Resource Group from the View list.

  3. Select the database or the resource group from the list.

  4. From the Manage Copies view, select Backups from storage system.

  5. Select the backup from the table, and then click the restore icon icon.

  6. In the Restore Scope page, select one of the following options:

    1. Select Restore the database to the same host where the backup was created to restore the database to the same SQL server.

    2. Select Restore the database to an alternate host if you want to restore the database to a different SQL server in the same or another host where backups are taken.

  7. In the Recovery Scope page, select one of the following options:

    1. Select None when you need to restore only the full backup without any logs.

    2. Select All log backups up-to-the-minute backup restore operation to restore all the available log backups after the full backup.

    3. Select By log backups to perform a point-in-time restore operation, which restores the database based on backup logs until the backup log with the selected date.

    4. Select By specific date until to specify the date and time after which transaction logs are not applied to the restored database.

    5. If you have selected All log backups, By log backups, or By specific date until and the logs are located at a custom location, select Use custom log directory, and then specify the log location.

  8. In the Pre-Ops and Post Ops page, specify the required details.

  9. In the Notification page, from the Email preference drop-down list, select the scenarios in which you want to send the emails.

  10. Review the summary, and then click Finish.

  11. Monitor the restore process by using the Monitor > Jobs page.