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 ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
