Identifying a Snapshot You Want to Restore To

To use a snapshot to restore data, you need to know the ID of the snapshot that provides the state you want to restore.

The ID of a snapshot is the same as the ID of the transaction whose commit caused the snapshot to be taken. When you want to restore to a particular state of a database, then you need to identify the snapshot that corresponds to the committed state of interest. For example, you can find the ID of the transaction that committed a known good state into the database by inspecting the SQL statement log. Or, you can search the SYSTEM.SNAPSHOTS table to find a snapshot that was created at a time the database was known to be in a good state.