SQL Server restores databases based on backup files. bak

Instead of creating a new blank database, follow these steps:

1. Open SQL Server Management Studio

2, on the "database" right click on the "Restore Database (R) ..."

3, enter the database name in the "target database"

4, in the "restored source" select "Source Device", click on the right button

5, in the pop-up "designated device" select "Add", select the backup file name, and then go back to the "Restore Database" window

6. Check each row in the "Select backup set to Restore" form, and complete it as determined