Search This Blog

Friday, April 2, 2010

How to restore a MSSQL Database

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