Restoring the SnapCenter database backup

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


  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:

    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.
    Specifies the SnapCenter Server URL. This URL is required when you are executing the PowerShell command from a database host.
    Specifies the name of the backup that is to be restored.

    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.


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