CREATE DATABASE teste_snapshot1
ON
( NAME = 'teste',
FILENAME = 'd:/teste_snapshot1.snap' )
AS SNAPSHOT OF teste
USE master
GO
RESTORE DATABASE teste
FROM DATABASE_SNAPSHOT ='teste_snapshot1'
GO
引自:http://www.sql-server-performance.com/articles/dba/Recover_Data_Using_Database_Snapshots_p3.aspx