MCITP

MCITP

Tuesday, September 11, 2012

Syntax to create Database Snapshot using T-SQL


Syntax :-

create database SnapshotName  on ( Name = Logical file name of DB , filename = 'C:\snapshotname.ss' ) as snapshot of Database name

Example :-

create database  test_snapshot on ( Name = test_new , filename = 'C:\test_new_snapshot.ss' ) as snapshot of test_new

No comments:

Post a Comment

Followers