Guest User

Untitled

a guest
Jun 25th, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. CREATE DATABASE Data_SShot
  2. ON (NAME=Data,
  3. FILENAME='C:SnapshotDataSnapshot.ss'),
  4. (NAME=Data_Data1,
  5. FILENAME='C:SnapshotData1Snapshot.ss'),
  6. (NAME=Data_Index1,
  7. FILENAME='C:SnapshotDataIndexSnapshot.ss')
  8. AS SNAPSHOT OF Data
  9.  
  10. use master
  11. go
  12.  
  13. RESTORE DATABASE Data
  14. FROM DATABASE_SNAPSHOT = 'Data_SShot'
Add Comment
Please, Sign In to add comment