How widespread is the adoption and usage of database snapshots?

After reading up on database snapshots, it seems that they are useful as a backup and quick restore method for small DDL and DML changes. Additionally they are useful for large scale dev/test environments.

My intended use will be in our test environment where we need to test DDL/DML scripts and want to revert to the previous state without requiring lengthy restore times. Are there other methods besides snapshots here (excluding VM solutions)? Has this been widely adopted and are there any issues to be aware of? I'm trying to get a sense of the community outside of MS documentation and the few blogs I have read. If your impression that the documentation available online is representative, that's a fine answer for me.

Thanks again, gurus!

Database snapshots are used in SQL Server 2005 or later every time you do a DBCC CHECKDB - so they are widely used, even if it is behind the scenes. Perhaps the biggest hindrance to adoption is that Management Studio didn't offer support.

It sounds like an ideal use of snapshots in a dev environment just for quick script deployments and quick roll backs. The only downsides, apart from no tools support, is to watch disk capacity where you put the snapshot file, and ensuring you don't have too many snapshot databases running on the server at the same time.

StackExchange Database Administrators Q#33360, answer score: 5