Conclusion
Criticisms aside, I’m glad that we have this feature—it’s a simple yet useful feature that can make a DBA’s life a little easier. The feature is very lightweight and extremely simple. It helps you guard against user errors and can be optionally used for reporting. It’s a novel technology that requires very little disk space. Even though the feature doesn’t provide a 100% foolproof guarantee against user errors, it’s a welcome edition to the SQL Server feature set. As a DBA, once you start working with DB Snapshot, you’ll surely find many uses for it!