SQL SERVER : Error 3154: The backup set holds a backup of a database other than the existing database

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

Here is the fix to this error:

Steps:

1) Use WITH REPLACE while using the RESTORE command

2) Delete the older database which is conflicting and restore again using RESTORE command.

RESTORE DATABASE Inventory
FROM DISK = 'C:\BackupInventory.bak'WITH REPLACE

You are actually  trying to restore the database on another existing active database.

Enjoy..this is the efficient fix