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