How to Restore an MSSQL Database in Management Studio?

Silicon House is a complete solution provider for reseller hosting, dedicated servers and cloud servers. Our expertise is in implementing high availability, high performance and hybrid cloud / dedicated servers.Silicon House runs hundreds of servers serving customers in more than 90+ countries.

Procedure to Restore an MSSQL Database in Management Studio.

1. Login to SQL Server Management Studio.
2. Navigate to the database you wish to restore.
3. Right Click > Tasks > Restore > Database.
4. Once on the General tab set the source to Device > Select Backup Device > Add > Navigate to the .bak file you’re restoring to.
5. Ensure The Destination Database is the correct one.
6. Select the Options tab.
7. Check Overwrite the existing database (WITH REPLACE) and Close existing connections to destination database.
8. Uncheck Take Tail-Log Backup Before Restore.
9. Click OK.