To create a snapshot using Microsoft MSSQL 2005 and reverting back to the snapshot can be performed with the following queries:

Creating a snapshot:

CREATE DATABASE Test_Snapshot ON ( NAME = logical_dnName_datafile,

'Test_snapshot.mdf' ) AS SNAPSHOT OF dbName

Using a snapshot:

USE Test_Snapshot
SELECT * FROM tableName

Reverting from a snapshot:

USE Master RESTORE DATABASE dbName FROM DATABASE_SNAPSHOT = 'Test_Snapshot'