How to Restore Database in SQL Server

In this article I am going to explain how to use database backup in SQL Server.
  • 1739

Introduction

In this article I am going to explain how to use database backup in SQL Server.  In SQL server we can make database backup using Enterprise Manager.  To create a database backup, SQL server dialog box is used. In this dialog box we need to put need to put name and description of database backup.

We use backup database when our database corrupted or crash.   

Steps to use database backup using Enterprise Manager in SQL server

Step 1 : Start SQL server :

Clipboard01.jpg

Step 2 : Expend database and select database => Right click on selected database => Now click on Task => Then click on Restore =>  Than click on database :

Clipboard02.jpg

Step 3 :  Restore dialog box appear  to restore database backup :

Clipboard12.jpg

Step 4 : Now verify database or select different database in database list box  for destination database :

Clipboard24.jpg

Step 5 : Now  specify the source and location of backup set to restore. Select from device :

Clipboard12.jpg

Step 6 : Dialog box appear, to add backup location click on "Add " button  :

Clipboard14.jpg

Step 7 : A new dialog box appear, we select backup file and click on "OK " :

Clipboard16.jpg

Step 8 : Now we see that file is selected and click on "OK" :

Clipboard18.jpg

Step 9 : Now in restore dialog box select restore file and click on ok to complete the process  :

Clipboard21.jpg


© 2020 DotNetHeaven. All rights reserved.