http://developers.de/blogs/damir_dobric/archive/2009/04/01/scripts-for-sql-server-snapshots.aspxJust for the sake of simplicity, I’m posting all three required scripts which create, drop and restore SQL Server Snapshot Databases. -- Create snapshot CREATE DATABASE TestDb_Snap1 ON ( NAME = TestDb , FILENAME = 'C:\Temp\\TestDbSnap.ss' ) ASenCommunityServer 2008 SP1 (Build: 30619.63)