USE [master] GO RESTORE DATABASE [DBName] FROM DISK = N'Path to BAK File' WITH FILE = 1, MOVE N'Logical File Name' TO N'New Path to mdf file', MOVE N'Logical File Log Name' TO N'New Path to log file', NOUNLOAD, REPLACE, STATS = 1 GO
RESTORE FILELISTONLY FROM DISK = N'path to bak file' WITH FILE = 1 GO
No comments:
Post a Comment