Sql2012 Database Restore

Sql2012 database Restore (backup files via. bak database)

Yesterday the system hung up, it called a miserable, re-installed the system, but sql2012 data is not backed up, colleagues to help send a backup file (. bak), start to restore data.

Step: 1 Create a new database of your own, which is the final restored database. (Fig. 1)

Figure A

2 Right-click on the "Shu Ju Huan Yuan" database--and task---Restore the database, results two

3 Selecting the restored data (restored backup set)

Select Restore by device-and then select the restored backup file (. bak)

Issue 1: End-of-log file backup issues:

Workaround:

Question 2:

The database in the backup set is different from the existing database "XXX" database

WORKAROUND: Option---Overwrite the existing database tick, as

Congratulations, the data restore success, Happy New Year!!!

Sql2012 Database Restore