How to Restore a Database in SQL Server 2008


Step 1:

  • Copy a backup file and paste it into your system (that means paste into any drive (D:/, E:/ ...))

Step 2:
  • Open SQL Server Management studio.

    RDatabase1.gif
     
  • Go to Object Explorer (it is located in the left side) in the SQL Server IDE.
  • Select "Database" and Right-click.
  • A window will open; in that window select the "Restore Databases.." Option.

    RDatabase2.gif
     
  • Another window will open.
  • That window has...
  • "Todatabase" option; you can give any Database name.
  • And select "From Device" radio button and go to browse ... and select "backup file".

    RDatabase3.gif
     
  • Specify Backup window; in that window click the "Add" button.

    RDatabase4.gif
     
  • The drives window displays; select your backup file from your system drives.

    RDatabase5.gif

    RDatabase6.gif
     
  • Click OK button.
  • Another wIndow displays; in that window ...
  • Check the "Restore" checkbox.

    RDatabase7.gif
     
  • Click "OK" button.
  • The MSQLMS window is displayed.
  • And click Ok.

    RDatabase8.gif
     
  • After completing all processes ...
  • Again go to "Object Explorer" and press the "Refresh" button.
  • Go to the database option and expand the database.

    RDatabase9.gif
     
  • "Project" is our database name

    RDatabase10.gif

Next Recommended Readings