Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE Data_SShot
- ON (NAME=Data,
- FILENAME='C:SnapshotDataSnapshot.ss'),
- (NAME=Data_Data1,
- FILENAME='C:SnapshotData1Snapshot.ss'),
- (NAME=Data_Index1,
- FILENAME='C:SnapshotDataIndexSnapshot.ss')
- AS SNAPSHOT OF Data
- use master
- go
- RESTORE DATABASE Data
- FROM DATABASE_SNAPSHOT = 'Data_SShot'
Add Comment
Please, Sign In to add comment