How to Restore a Backup of Database in SSMS

Introduction

If you are new to SQL Server Management Studio (SSMS), you might be wondering how to restore database in SQL Server Management Studio from a backup. Whether your database was created on-premise, backed up from Azure SQL backup, or exported as a .bak file, this step-by-step guide will help you understand how to restore database in SSMS easily.

We will walk through restoring a SQL backup database from a .bak file, configuring restore options in SQL Server, and handling common tasks such as deleting users and fixing user mapping issues after restore.

Step-by-Step Guide to Restore DB Backup in SSMS

Step 1: Run the SSMS from the Start Menu

Step 2: Restore the Database

1. Connect to the Server
   
2. Choose the Database
   
3. Right-click on the Database Name “test” and click “Tasks”. Click “Restore”, then click ”Database”.
   
4. Choose “Device”, then click “…”
   
5. Select the Backup Devices
   
6. Find the Backup Database from the Folder
   
   
7. Restore the Database
   
8. Choose “options” and Restore the Options. Overwrite the existing database (WITH REPLACE)
   
9. Restored successfully
   
10. Delete the Database Existing User
    
11. Delete the Object
    
12. Connect to User mapping
    
    
    

Step 3: Done