The backup set holds a backup of a database other than the existing database.

[Angela]

Today morning, I have faced errors after restore database on SQL Server Management Studio. Then I executed few commands, but error appear again.

Error 3154- "The backup set holds a backup of a database other than the existing database".

After executing commands I got surprised errors. To fix this problem, I have read a blog and found a solution. Then I have followed below procedure:
1. Select Database backup
2. Click on GoTo tab
3. Click on First Restore Operation

There is no benefit to follow this procedure because error occur again. Then I found same problem over Atlassian, Stack Exchange and many other forums which I have shared link here. Please help which one is best solution.
https://community.atlassian.com/t5/Jira-Software-questions/SQL-Server-Connecting-Database-Error/qaq-p/845999
https://www.essentialsql.com/error-3154-restore-sql-database/
https://www.stellarinfo.com/sql-recovery.php

[Andy Heinzer]

It sounds like you are trying to restore a database backup to an existing database.  One way you could get around this would be to instead, create a new empty database first, and then attempt to restore this SQL backup to this new database instead.

Alternative to this, by default Jira is actually creating an XML backup of your database every 12-24 hours.  These are automatically stored in your $JIRAHOME/export/ folder.  These are stored in .zip files, each file should contain a activeobjects.xml and entities.xml file only.    Knowing this, you could use one of these backups to restore this Jira data to a new empty database.   Since it sounds like you are using SQL 2012, I would recommend following the steps in Connecting Jira to SQL 2012 in order to create this new empty database for Jira correctly.   Once the database is created, you can edit your $JIRAHOME/dbconfig.xml to connect to this new, empty database, save that change and restart Jira.

When Jira starts up connected to an empty database, it will automatically launch the setup wizard.   That wizard has a link called 'import existing data'.  Clicking this will allow you to import that XML backup .zip file into the new empty database.   You will need to copy that XML backup zip file from the $JIRAHOME/export/ folder into the $JIRAHOME/import/ folder.   This way you can import that backup into a fresh database.   This tends to be a better way to recover Jira data, rather than trying to overwrite an existing database which implies dataloss.