How to restore Database in sql server


In this article I have explained about how to Restore Database using SQL Server. Each steps I have clearly explained in this article.

How to Restore Database using SQL Server



In this article I have explained about how to Restore Database using SQL Server.
Each steps I have clearly explained in this article



Step 1: Open SQL Server management Studio
Step 2:Connect to the appropriate Server and right click databases.
Step 3:Select Restore Database then click it (see below image).

Step 3 Restore Database

Step 4:Restore Database Window will display (See below image).

Step 4 Restore Database Window

Step 5:Give Restore Database name (see below image).

Step 5 Restore Database name


Step 6:Select from database or from the device (Here I''m selecting from Device).
Step 7:Click the button nearest from the device. (see below image)

Step 7 From the device

Step 8:Specify Backup window will display (see below image)

Step 8 Specify Backup window

Step 9:Click add button and you will get Locate Backup file-Servername window.
Step 10: select your bak files.

Step 11: then click the ok button.
Step 12:Your path will display in Specify Backup window.If an unwanted path is displayed then remove it.
Step 13: if does not have more then one path then click the ok button.
Step 14:The database backup file path will display in Restore database window (see below image)
Step 14 Database Restoring

Step 15: select latest Restore database file.
Step 16: finally click ok button


Step 17: if your database is already in the server then click the options button Click the overwrite the existing database (With Replace) checkbox.


Attachments

  • Step 3 Restore Database (43947-61756-Step-3-Restore-Database.bmp)
  • Step 4 Restore Database Window (43947-6208-Step-4-Restore-Database-Window.bmp)
  • Step 5 Restore Database name (43947-62310-Step-5-Restore-Database-name.bmp)
  • Step 7 From the device (43947-62527-Step-7-From-device.bmp)
  • Step 8 Specify Backup window (43947-6315-Step-8-Specify-Backup-window.bmp)
  • Step 14 Database Restoring (43947-63334-Step-14-Database-Restoring.bmp)
  • Comments

    Guest Author: bharani16 Jul 2012

    i have one QA
    if i have 10.0.1600 version of sql server 2008, but my client have sql server R2 version no 10.50.2500 . if i get database backup from my client machine, but I couldnt restore in my local machine.
    i know the version is conflicts the sql back up.



  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: