ExceptionTemplates failed in SQL Server

Error message in SQL Server:

Sometimes, If we try to restore a database backup. We will get the below error,

Restore failed for Server 'SQLDB'. (Microsoft.SqlServer.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------
The backup set holds a backup of a database other than the existing 'Venkat' database.
------------------------------------

Reason for this issue:

This issue arises due to improper installation of SQL Server or improper software . We need to install SQL Server from proper installation disk or As a work around, we can execute the below query to restore your backup.

Solution for this issue:

If you face the above issue, execute the below query.

RESTORE DATABASE [Venkat]
FROM DISK = N'D:\Venkat.BAK'
WITH REPLACE

Cheers,
Venkatesan Prabu .J