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. With the current release of SQL Server Management Studio, you cannot even set up database snapshots with this GUI or a wizard; it must all be done using T-SQL statements (which is not that bad a deal). The following are some of the other restrictions:
• You must drop all other database snapshots when using a database snapshot to revert a source database.
• You lose visibility to the source database’s uncommitted transactions in the database snapshot when it is created.
• The more updates to pages in the source ...
Get Microsoft® SQL Server 2008 R2 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.
