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.)


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

"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 © 1999-2024
Some rights reserved