1. This Transact-SQL creates a snapshot of the database: CREATE DATABASE ION_Data_Snap ON (name='ION_Data_Data', filename='C:\ION\Database\ION_Data.ds') AS SNAPSHOT of ION_Data; GO 2. This Transact-SQL restores from a snapshot: RESTORE DATABASE ION_Data FROM DATABASE_SNAPSHOT = 'ION_Data_Snap'; GO 3. This Transact-SQL drops the snapshot database: DROP DATABASE ION_Data_Snap GO