Comprehensive Guide to Restoring Databases in SQL Server

In this tutorial I will show you how to restore database. In SQL Server, you can restore a database very easily. To restore a database right click on the Databases node, then select Restore Database...

1. Select Device
2. Click on three dot

Click on Add button. Then add your backup file.

1. Go to the backup file location
2. Select backup file
3. Click OK

1. You can see the file
2. Click on OK

1. You can change the destionation Database name

You can change the logical file name

After clicking on Ok button you will get a success message.

Now you can check your database node you will be able to see you database which you restored.