Grammar:
Restore Database Db_name
From database_snapshot = ' db_snapshot_name ';
--------------------------------------------------------------------------------------------------------------- -------------------
Example:
Restore Database AdventrueWorks2012
From database_snapshot = ' adventrueworks2012_snapshot ';
Go
------------------------------
Attention:
1. You cannot manually create a snapshot of master tempdb Modle, although it is possible for SQL Server to do so internally. When it is this ability does not open up.
2, the snapshot inherits the security constraint of the source database, because it is read-only, so there is no way to change.
3. If the user is deleted from the data source, the user will also be in the snapshot.
4. You cannot back up and restore the database.
5. You cannot attach and detach a snapshot.
6. Full-text indexing is not supported.
SQL Server restores the database from a DB snapshot