Wednesday, July 16, 2008

How to Restore a MSSQL backup (.bak)

Run the command in MSSQL to restore a .bak file

RESTORE DATABASE [abc]
FROM DISK = 'C:\backup_200807102327.bak'
with move 'abc' to 'C:\Database\abc.mdf',
move 'abc_LOG' to 'C:\Database\abc.LOG',
Replace
GO

No comments:

Post a Comment