How to create a snapshot a DB in sql server

Karthikanbarasan
Posted by Karthikanbarasan under Sql Server category on | Points: 40 | Views : 2652
CREATE DATABASE SampleDBSnapShot ON
(NAME = 'SampleDBPrimary', FILENAME = 'D:\backup\SampleDBPrimary.mdf'), (NAME = 'SampleDBdata1', FILENAME = 'D:\backup\SampleDBData1.ndf'), (NAME = 'SampleDBdata2', FILENAME = 'D:\backup\SampleDBData2.ndf')
AS SNAPSHOT OF SampleDB

Comments or Responses

Login to post response