The backup set holds a backup of a database other than the existing ‘DB Name’ database.

Restore failed for Server ‘SQL Server name‘. (Microsoft.SqlServer.Smo)

System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing ‘dbName‘ database. (Microsoft.SqlServer.Smo)

 

http://www.linglom.com/it-support/solved-system-data-sqlclient-sqlerror-the-backup-set-holds-a-backup-of-a-database-other-than-the-existing-dbname-database/