How to Import/Restore SQL Database (.bak Files) in SQL Server

Posted On December 9, 2021 by Shruti Gupta Posted in  Tagged in ,

In this blog we will see how to import/restore SQL Database (.bak) file in SQL Server. If you have a new downloaded .bak file or the Backup of any other database in .bak file format then you can import/restore it in your SQL Server.

  • Open SSMS and Connect to your SQL Server
  • Expand the SQL Server, Right Click on the Database and choose Restore Database
  • In the General settings, Select Device and then the three ellipsis.
  • Click on Add to add the .bak file.
  • Select the file location and then select the .bak file and click OK.
  • Click OK and your Database will be restored.

Related posts:

How to Enable SQL Server Authentication for your Local Server in SSMS
How to set different connection colors in SSMS
Displaying Line Number in SSMS Query Editor
Use Web Browser along side SQL Query editor

Share Story :

SEARCH BLOGS :

FOLLOW CLOUDFRONTS BLOG :


Secured By miniOrange