To Create Database Snapshot
database #database
create database databasesnapshotname on ( name = logicalfilenameofsourcedatabasemdffile,
filename = 'path(snapshotpath)\filename(snapshotphysicalfilename).ss') as snapshot of sourcedatabasename;
gocreate database databasesnapshotname on ( name = logicalfilenameofsourcedatabasemdffile,
filename = 'path(snapshotpath)\filename(snapshotphysicalfilename).ss') as snapshot of sourcedatabasename;
go