How to Create Database Snapshot in SQL Server
How to Create Database Snapshot in SQL Server
Below Script will create Database snapshot in SQL Server.
CREATE DATABASE AdvantureWorks_ss1 ON
(NAME = AdventureWorks2014_Data, FILENAME = 'E:\DBSnapshot\AdvantureWorks1.ss')
AS SNAPSHOT OF [AdventureWorks];
GO