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

Sdílet
Vložit
  • čas přidán 16. 05. 2020
  • 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:
    / cbtechnologies
  • Věda a technologie

Komentáře • 49