I have two MS-SQL Server 2008 databases (same structure) but different names on two machines. I have made a backup from machine A and want to restore it on machine B. However, when I restore it on machine B I get following error:
“The backup set holds a backup of a database other than the existing ‘mydb’ database”.
Can somebody give some idea what is wrong and how I can fix it?