Thursday 19 July 2012

Command Restore MS SQL Database

Type all this command on Query workspace...

RESTORE DATABASE [My_Database]
FROM DISK = 'c:\Content.bak'
WITH
          MOVE 'My_Database_Data TO 'c:\Data\My_Database_Data.mdf',
          MOVE 'My_Database_Log TO 'c:\Data\My_Database_Log.ldf',
REPLACE,
STAT = 10

Click button Execute ...

Good luck

No comments:

Post a Comment