Create Database Snapshot Dynamically

Dynamic SQL can be used to generate a database snapshot. Useful for a database with a number of files.

Automated Rapid Recovery during Database Code Releases using Snapshots

Leveraging snapshots across multiple databases simultaneously to allow for quick rollback in case of a problem deploying code

Alas Poor Snapshot, I Knew Him Well

Quick snapshot

Script enables a quick creation of snapshots for databases

Successfully execute an INSERT, UPDATE and DELETE against a Database Snapshot

Not too long ago an ISV that developed solutions using SQL Server as the RDBMS, asked me how they could query a database as at a point in time. This was a relatively easy answer, thanks to the Database Snapshot feature. I was however surprised at the next question “Can we update the database snapshot?”

Snapshots