Restore command

Use this command to restore one (or more) SQL databases from storage that is managed by IBM Spectrum Protect Snapshot to a SQL Server.

Considerations:
  • You cannot restore SQL databases currently in use. By placing SQL databases to be restored in single-user mode, you can avoid attempting such restores. If you are restoring the master database, you must start the SQL Server in single-user mode by using the -m SQL SERVER startup option.
    Note:
    1. The single user of the SQL databases or server must be the same user that IBM Spectrum Protect Snapshot uses to log on to the SQL Server for the restore.
    2. SQL Enterprise Manager, SQL Server Application Client, and other SQL Server services can be users of databases and the SQL Server.
  • The user that is used by IBM Spectrum Protect Snapshot to log on to the SQL Server must have the SQL Server SYSADMIN fixed server role.
  • You can use the TRANSACT-SQL database consistency checker statement DBCC CHECKDB ('DBNAME') to verify the integrity of the restored SQL databases.