title: VB.NET restore Backup file created on one server to another server
body: <p>i am using SQL server express 2005 as an backend. I created a backup file programmatically.If i use same server , then it restore the data successfuly. however if we try to restore on different server, then it fails. and throw following message</p>
  
  <p><strong>"The Backup set Holds a backup of a database other than the existing 'DatabaseName' database. RESTORE DATABASE is terminating abnormally</strong>."</p>
  
  <p>On both server, Sql server instance name and database name is same.
  Please suggest how can i resolve this error</p>