Open topic with navigation
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.