Advertisement
Guest User

Untitled

a guest
Jun 27th, 2019
174
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. RESTORE DATABASE JA FROM DISK='c:glynJA.bak'
  2.  
  3. USE [master]
  4. RESTORE DATABASE [MyNewDB] FROM
  5. DISK = N'D:MyOldDB.bak'
  6. WITH
  7. FILE = 1, -- 1 = .bak, 2 = .trn type backup
  8. MOVE N'MyOldDB' TO N'd:dataMyOldDB.mdf',
  9. MOVE N'MyOldDB_log' TO N'd:dataMyOldDB_log.ldf',
  10. NOUNLOAD,
  11. STATS = 5
  12. GO
  13.  
  14. SELECT @@Version
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement