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 record of the SQL Server2008 3154 error Resolution, we hope to help.

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

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,

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,

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,

SQL Server Restore Database failed: Error: 3154