Restore SQL Server DataBase from a Backup

Now we are going to see how to restore a database backup in MS-Sql Server using management studio.

1. Connect to the database server in sql server management studio. For example localhost. Right Click on the “Databases” and Choose “Restore Database” option

Image

2. This will Open the restore database window. Enter the name of the database that you want to create in the “To Database” Field. Here I have entered my database name as “TEST”

Image

3. Choose the option “From Device” and click on the browse button.Now locate the backup file “.bak” file and give Ok.

Image

4. This will navigate you to “Specify Backup” directory. where your backup file will be specified. You can remove that file here bu remove button and add the new database backup file using “add” button.

Image

5. Give “OK” in the “Specify Backup” window. This will navigate you to the “Restore Database” screen and select the “Restore” check box in that window.

 Image

 

6. Click on the Options page and there you may specify the path for your database to be created. 

Image

7. Again Goto “General” Page and Click the Ok button.

Image

8. You can see the progress the the Left side bottom in % and once the restore is complete you should get a prompt as 

Image

 

Thats it. Now the new database “TEST” has been created and you can play with it.

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s