How to restore a SQL Server2012 database from a bak file in SQL Server2012

1 after landing the database, do not create a new database, directly click on the "database" and then right-click "Restore Database."

2 Select devices in the source option.

3 Select the appropriate bak file and add it.

4 Click OK after adding, note that in the target column, the database name can not be written, note check the data set to be restored.

5 Click "OK" to restore the backed up database.

Note: In the restoration of the note is not the first to set up the database, so that the restoration may be due to the backup Bak file and the new Database data table is different, so often cause a restore error, so generally do not need to create a new database, direct restore is good!

How to restore a SQL Server2012 database from a bak file in SQL Server2012