SQL Server Performance, DBA Best Practices & Enterprise Data Solutions | MyTechMantra
FacebookXPinterestEmailGoogle+LinkedInWhatsApp
DBADevelopersSQL Server

How to Restore Database in SQL Server?

Ashish Kumar Mehta
4 min read

Step 4. In Specify Backup dialog box choose File as Backup Media and then click the Add button to choose the location of database backup file from which you want to restore the database as shown in the below snippet. Click OK to return to Restore Database dialog box.

Specify Database Backup Location in SSMS

Step 5. In Restore Database Dialog box select the checkbox under Restore as shown in the below snippet and then select Option Page from the left pane.

How to Restore Database Using SQL Server Management Studio

Step 6. In Options Page of Restore Database dialog box select the checkbox next to Overwrite the existing database (WITH REPLACE) and choose the radio button next to Leave the database ready to use by rolling back uncommitted transactions. Additional transactional logs cannot be restored. (RESTORE WITH RECOVERY) as shown in the below snippet. Finally, click OK to start restoring the SQL Server Database.

Restore Database Dialog Box Options Page in SQL Server Management Studio


Click the below Number Buttons to continue reading the rest of the article.

1 2 3

Ashish Kumar Mehta

Ashish Kumar Mehta is a distinguished Database Architect, Manager, and Technical Author with over two decades of hands-on IT experience. A recognized expert in the SQL Server ecosystem, Ashish’s expertise spans the entire evolution of the platform—from SQL Server 2000 to the cutting-edge SQL Server 2025.

Throughout his career, Ashish has authored 500+ technical articles across leading technology portals, establishing himself as a global voice in Database Administration (DBA), performance tuning, and cloud-native database modernization. His deep technical mastery extends beyond on-premises environments into the cloud, with a specialized focus on Google Cloud (GCP), AWS, and PostgreSQL.

As a consultant and project lead, he has architected and delivered high-stakes database infrastructure, data warehousing, and global migration projects for industry giants, including Microsoft, Hewlett-Packard (HP), Cognizant, and Centrica PLC (UK) / British Gas.

Ashish holds a degree in Computer Science Engineering and maintains an elite tier of industry certifications, including MCITP (Database Administrator), MCDBA (SQL Server 2000), and MCTS. His unique "Mantra" approach to technical training and documentation continues to help thousands of DBAs worldwide navigate the complexities of modern database management.

View all posts

You may also like

Follow us

Don't be shy, get in touch. We love meeting interesting people and making new friends.