December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Limitations and Restrictions of Database Snapshots
Many restrictions or limitations are involved with using database snapshots in SQL Server. Some of them are pretty restrictive and may determine whether you can consider using snapshots. For example, even in SQL Server Management Studio 2012, you still cannot set up database snapshots or revert a database to a snapshot via the GUI or a wizard; it must all be done using T-SQL statements. The following are some of the other restrictions and limitations associated with database snapshots:
You must drop all other database snapshots when using a database snapshot to revert a source database.
You ...