Skip to main content
SnapCenter Software 6.0

Restore and recover SQL Server databases

Contributors netapp-soumikd
PDFs

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

About this task

You should ensure that the target instance for restore is configured with an active directory user who belongs to the SMB ADactive directory domain and has permissions to set the file permissions appropriately. You should configure the credentials in SnapCenter at instance level.

The SQL authentication for target instance will not be supported for SMB configurations. The target instance should be configured in SnapCenter with the active directory user having the required permissions.

If the SnapCenter Plug-in services service account is not an active directory user then while performing restore to alternate host, the user who have the full control over the source volumes is required so that it can be impersonated and perform the required operation.

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 if you want to restore the database to the same SQL server where the backups are taken.

    2. Select Restore the database to an alternate host if you want the database to be restored to a different SQL server in the same or different 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.