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