How to restore .bak file in SQL Server Management Studio 2019

How to open and import a .bak file to a database in SQL Server Management Studio 2019

Step 1: Copy your own .bak file that you downloaded

Step 2: Go to “OS(C:)/Program Files/Microsoft SQL Server/MSSQL 15.MSSQLSERVER/MSSQL/Backup” and then paste the .bak file

Step 3: Go back to SQL Server Management Studio, click on Databases and right-click and choose Restore Files and Filegroups

Step 4: At “Destination to restore” enter the database name of the .bak file. At “Source for restore” click “Form device” and click the 3 dots to select the .bak file from your device

Step 5: Click Add then it will automatically detect where you have pasted the file in the Backup folder, just click on the .bak file you need to open. Then click OK and OK

Step 6: In the “Select the backup sets to restore” section do not forget to check the Database Backup then click OK and when Database restored successful click OK

Step 7: click refresh or F5 key and you will see your database

—————–Follow us——————
Twitter:
https://twitter.com/CbTechnologies