Microsoft SQL Server Database Snapshots Restore a database snapshot
Example
If data in a source database becomes damaged or some wrong data is written into database, in some cases, reverting the database to a database snapshot that predates the damage might be an appropriate alternative to restoring the database from a backup.
RESTORE DATABASE MYDATABASE FROM DATABASE_SNAPSHOT='MyDatabase_morning';
Warning: This will delete all changes made to the source database since the snapshot was taken!
