a guest Jun 27th, 2019 73 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- RESTORE DATABASE JA FROM DISK='c:glynJA.bak'
- USE [master]
- RESTORE DATABASE [MyNewDB] FROM
- DISK = N'D:MyOldDB.bak'
- FILE = 1, -- 1 = .bak, 2 = .trn type backup
- MOVE N'MyOldDB' TO N'd:dataMyOldDB.mdf',
- MOVE N'MyOldDB_log' TO N'd:dataMyOldDB_log.ldf',
- STATS = 5
- SELECT @@Version
RAW Paste Data