O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

Image You must drop all other database snapshots when using a database snapshot to revert a source database.

You ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required