Last night, I was restoring database from backup. For some reasons, I got an error as below:
System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'database-name' database. (Microsoft.SqlServer.SmoExtended)
For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=15.0.18206.0+((SSMS_Rel).191029-2112)&LinkId=20476
After scratching head for sometime, I realized that I was trying to restore the database backup to an empty database. Silly me! I tried restoring database backup from Databases tree in Object Explorer and it worked like a charm.