sp_helpdb MyTest
go
-- The following script is easiest way to create a Snapshot database.
CREATE DATABASE MyTest_snapshot_db ON
( NAME = MyTest,
FILENAME = 'D:\MSSQL\DATA\MyTest_snapshot_db.ss' )
AS SNAPSHOT OF MyTest;
go
Note: Remember you can't create a snapshot database using SSMS but you can delete snapshot database using ssms.
go
-- The following script is easiest way to create a Snapshot database.
CREATE DATABASE MyTest_snapshot_db ON
( NAME = MyTest,
FILENAME = 'D:\MSSQL\DATA\MyTest_snapshot_db.ss' )
AS SNAPSHOT OF MyTest;
go
Note: Remember you can't create a snapshot database using SSMS but you can delete snapshot database using ssms.