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

I was trying to restore Sql server backup file for my database , but its throwing an error as follow

Solution:
Don't create an empty database and restore the .bak file on to it.
Use 'Restore Database' option and provide the database name while providing the source to restore.