Monday, April 23, 2012

Creating a snapshot

Time to learn something about creating a snapshot  of a database so I wrote a script

CREATE DATABASE [Snapshot Name for queries] ON
( NAME = [Name of the logical to be snap shot, this should include the date time to allow multiple days], FILENAME = 'e:\BackupforSnapshot_20120420.ss' )
AS SNAPSHOT OF [Database to be snap shot name];
GO

No comments: