I was trying to restore a database from the windows server 2008 database backup in my local. I was doing through object explorer and was getting "Error 3154: The backup set holds a backup of a database other than the existing database." To fix the issue I tried it with below SQL statements from Query Analyzer. After executing the below commands I was able to restore successfully. RESTORE DATABASE DataBaseName FROM DISK = 'C:\DataBaseName.bak' WITH REPLACE