RESTORE Database

Revert to a Database Snapshot:

   RESTORE DATABASE { database | @database_name_var } 
         FROM DATABASE_SNAPSHOT = database_snapshot

This will restore the snapshot (to the same server/database/schema name.)

Example

USE master  
RESTORE DATABASE ss64Database FROM DATABASE_SNAPSHOT = 'ss64_snapshot01';
GO

"There is no safety in numbers, or in anything else" - James Thurber

Related commands:

Complete Restore - an Entire Database from a Full database backup.
Partial Restore
- part of database/point in time
Restore Files
- Files, Filegroups, or Pages
LOG Restore - a Transaction Log
RESTORE FILELISTONLY - List database and log files
RESTORE VERIFYONLY - Verify the backup but don't restore it
Equivalent Oracle command: RMAN - Recovery Manager


© Copyright SS64.com 1999-2014
Some rights reserved