Error 3154:The backup set holds a backup of a database other than the existing 'AXDBDEV' database

This error message  will produce when we restore our database from the database backup file:

There are following easy steps to resolve this issue:

Step 1: 

First right click the existing database which you want to restore than go to:

 

task => restore => database

 

as you can see in the below image:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Step 2:

A new wizard will open.Now click on the options then check the checkbox

 

"Overwrite the existing database (with replace)" 

 

as you can see in the below image.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Now perform the rest of the steps for restoring the database.The error message will not be produce again.

 

 

Thanks

 

Muhammad Zahid.