sqlserver2008 database backup Import SQL Server 2016 (new database)

因为需要把sql2008上的备份数据库导入到本机使用，而且不能采取分离、附加数据库的方式。好久没搞sqlserver了，到处度娘，mark一下。

1. Open Microsoft SQL Server Management Studio (2016 of ssms is required to download)

2. Create a new database:

3. On the newly established database, right--task-Restore-database; Click Device to select the backed up database:

4, check the restore, determined after the error:

5, click on the option, tick overwrite the existing database, do not check the end of the log backup (if checked, because it is a new database no log so will error), click Confirm, restore success!

sqlserver2008 database backup Import SQL Server 2016 (new database)