Advertisement
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'
- WITH
- 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',
- NOUNLOAD,
- STATS = 5
- GO
- SELECT @@Version
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement