Restoring the SnapCenter database backup

You can restore the SnapCenter database when required by running the Restore-SmRepositoryBackup comdlet.

Steps

  1. Launch PowerShell.
  2. From the command prompt, enter the following command, and then provide credentials to connect to the SnapCenter Server: Open-SMConnection
  3. Restore the backup using the Restore-SmRepositoryBackup command and options: Restore-SmRepositoryBackup [-HostName] string [-BackupName] string [[-SMSbaseUrl] string] [[-RestoreFileSystem]]

    The options are as follows:

    HostName
    Specifies the SnapCenter Server host name. For standalone configuration, you must specify as localhost. For network load balancing (NLB) configuration, you must provide the host name of the SnapCenter Server where the iSCSI LUN or VMDK is configured for repository protection.
    SMSbaseUrl
    Specifies the SnapCenter Server URL. This URL is required when you are executing the PowerShell command from a database host.
    BackupName
    Specifies the name of the backup that is to be restored.
    RestoreFileSystem

    This is an optional parameter. This parameter is used when your backup files are corrupted or accidentally deleted from iSCSI LUN. For VMDK, you must manually restore the accidentally deleted or corrupted backups from ONTAP Snapshot copies.

Example

The following cmdlet restores the SnapCenter MySQL database from the backups existing on either iSCSI LUN or VMDK:

 C:\PS>Restore-SmRepositoryBackup -BackupName MYSQL_DS_SC_Repository_mva-x3550-s09_09-15-2016_10.32.00.4445
The following cmdlet restores the SnapCenter MySQL database when backup files are deleted accidentally in the iSCSI LUN. For VMDK manually restore the backup from ONTAP Snapshot copies.
C:\PS>Restore-SmRepositoryBackup -BackupName MYSQL_DS_SC_Repository_mva-x3550-s09_09-15-2016_10.32.00.4445 -RestoreFileSystem