Restore Database

The database must be restored, but the server is functional and other databases remain available. The restore requires application of a full database backup followed by application of one or more transaction log backups. The full database backup is a hardware-assisted snapshot.

Steps

• Restore the snapshot with norecovery.
  
  
• Apply log backups and recover.

Data and log files can be relocated by using the MOVE option. The snapshot files are placed in their new locations by the snapshot provider; MOVE specifies the new pathname.

A very similar scenario can be described in which only the damaged files are restored. The only difference is in the restore command issued and the snapshot files restored by the provider. Point-in-time recovery is not an option, since all the restored files will need to be restored to the end of log, consistent with the files that were not restored.

Snapshot restore of the master database is not supported. If a snapshot backup of the master database was taken, it can be restored by stopping the SQL Server service, copying the master files, and then restarting the service.