While restoring the database I got a peculiar issue and started googling for the same. Got a link from Microsof BOL about this issue.
Reason for this issue: You are trying to restore the database on the existing database.
SQL Server is thinking that the new restore database is a tail database for the existing database available in the system . Due to this, it's trying to check for the tail end.
Solution : We need to delete the existing one and add the new one
or else Goto the options page of the restore window and you need to select the option “overwrite the existing database (With replace )
Cheers,
Venkatesan Prabu .J
Head, KaaShiv InfoTech