SQL Server Restore Database failed: Error: 3154

Error when restoring a database backed up from SQL Server 2005 in the SQL Server 2008 release: "The database backup in the backup set is not the same as the existing ' * * * ' database. RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154) ".

Here is a small record of the SQL Server2008 3154 error Resolution, I hope to be of help to everyone.

Baidu Experience: jingyan.baidu.com

Tools/Materials

• SQL Server2008

Baidu Experience: jingyan.baidu.com

Cause analysis

1. 1

   In SQL Server2005 and the following version of the database backup to restore, you need to establish a database before the database restore operations, and in SQL Server2005 version of the database restore, do not need to establish a database, you can directly perform database backup operations, Otherwise, a 3154 error is reported when performing a database restore operation.

   END

Baidu Experience: jingyan.baidu.com

SQL Server2008 Database restore operation instance

1. 1

   Take the Restore test database as an example.

2. 2

   First start the SQL Server2008 software, expand the left tree, right-click on the "Database" node, pop-up context menu,

   Steps to read
3. 3

   Select the "Restore Files and Filegroups (E) ..." feature, pop up the "Restore Files and Filegroups" dialog box, fill in the database name in the "Target database (Q)" column in the restore target, fill in the test, select "Source Device" in the restored source, click the button in the red box on the right,

   Steps to read
4. 4

   In the "Specify Backup" dialog box, select the "Add" button, pop up the "Select File" dialog box, select the location of the database backup, select and click Confirm, in the "Specify Backup" dialog box will display the database backup list, select the database backup you want to restore, click OK to start the database recovery,

   steps to read END

SQL Server Restore Database failed: Error: 3154