Listing 1: Syntax for Creating a Snapshot

CREATE DATABASE AdventureWorks_snapshot ON
( NAME = N'AdventureWorks_Data',
 FILENAME =  
 N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AW_snapshot.mdf')
AS SNAPSHOT OF AdventureWorks