Step 1:
RESTORE FILELISTONLY
FROM DISK = 'D:BackUpYourBaackUpFile.bak'
Step 2:
RESTORE DATABASE YourDB
FROM DISK = 'D:BackUpYourBaackUpFile.bak'
WITH MOVE 'YourMDFLogicalName' TO 'D:DataYourMDFFile.mdf',
MOVE 'YourLDFLogicalName' TO 'D:DataYourLDFFile.ldf'
No comments:
Post a Comment