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 “ 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
Back to Top