MS SQL Restore Backup

SQL Server Backup and Restore with SSMS using BAK File

With SSMS and the T-SQL command, we can easily restore backup file (.bak). Follow the steps listed below to know how to restore SQL Database from backup using SSMS utility.

Step 1. Open SSMS and connect to your database

Step 2. Select the database and right click >> Tasks >> Restore >> Database

Step 3. In the Restore Database window, select From device under Source for restore section and click the Browse (…) button.

Step 4. Specify Backup window will open, set Backup media as File and click Add button for learning how to backup database in SQL Server.

Step 5. Select backup file which you want to restore and click OK.

Step 6. The .bak file will be list on the Restore Database window. Click OK

Step 7. Now, click on Options from the left side, select your desired Restore options and Recovery state

Step 8. In the end, click OK.