How to restore a MSSQL 2005 database

To restore MSSQL 2005 Database from a backup file say data.bak which you have backed up from a database , first place the backup file in the following location
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup .

Then login to the MSSQL management studio using windows authentication or SQL server authentication , Expand databases in the left pane , Right click on the database which you want to restore ==> tasks ==>Restore ==>database

Then select the “from device” option and browse the path where you have copied the database backup file data.bak which is C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\data.bak

Check the restore check box and click options . From the restore options select overwrite the existing database option and provide the correct path for the .mdf and .ldf files say C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\data.mdf and C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\data_log.ldf .

Click ok to restore the database and you will get a message that the restore of the database was completed successfully .

Comments are closed.

(adsbygoogle = window.adsbygoogle || []).push({}); //--> Feedjit Flag Counter