SQL Server Snapshot CREATE DATABASE MirrorTestDB_snapshot ON ( Name = MirrorTestDB, FileName = 'C:\MirrorTestDB_ss.mdf' ) AS SNAPSHOT OF MirrorTestDB use MirrorTestDB_snapshot go Dev::SQL Server 2012.09.07