//Puts database in snapshot isolation mode
ALTER DATABASE EZ_KendallMarcelSET ALLOW_SNAPSHOT_ISOLATION OFF
ALTER DATABASE EZ_KendallMarcel
SET READ_COMMITTED_SNAPSHOT OFF
//Determines the current state of Snapshot Isolation Mode and Read Commited
SELECT snapshot_isolation_state_desc, is_read_committed_snapshot_on
from sys.databases
where name = 'EZ_KendallMarcel'
//Finding the Logical Disk Name of a databse for use in a SQL Database Snapshot [NAME]
SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files
WHERE database_id = DB_ID(N'EZ_KendallMarcel')
//Creating a SQL Database Snapshot
CREATE DATABASE EZ_VicDatabase_dbss1800 ON ( NAME = AdventureWorks_Data, FILENAME = 'F:\SQLSnapshots\EZ_VicDatabase_dbss1800.ss' )
AS SNAPSHOT OF EZ_VicDatabase;