Problem Arise when restore Bak file of one server to another server
-
hi all, in my application, i use MSSQL express 2005 as backend. when i create backup file from one server (say A) and restore it on same server (A), then it works well. but if i restore the Backup file of Server A to another server (say B), then it give error as following "The Backup set Holds a backup of a database other than the existing 'DatabaseName' database. RESTORE DATABASE is terminating abnormally." on both server instance name and database name is same please suggest how can i resolve this error
rup28aug@yahoo.co.in Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) My Company Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11
-
hi all, in my application, i use MSSQL express 2005 as backend. when i create backup file from one server (say A) and restore it on same server (A), then it works well. but if i restore the Backup file of Server A to another server (say B), then it give error as following "The Backup set Holds a backup of a database other than the existing 'DatabaseName' database. RESTORE DATABASE is terminating abnormally." on both server instance name and database name is same please suggest how can i resolve this error
rup28aug@yahoo.co.in Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) My Company Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11
-
before taking backup check some point 1.where the mdf file located(is there any folder which is contain .mdf) 2.when u r creating .bkp file always use overwrite existing file option.
Thanks and Regards Sujit Kr. Mandal
Sujit Mandal wrote:
1.where the mdf file located(is there any folder which is contain .mdf)
mdf and ldf file is located on shared folder (for example c:\abc or E:\abc) folder abc is shared which i create programmatically
Sujit Mandal wrote:
2.when u r creating .bkp file always use overwrite existing file option.
i already check whether there are any file with same name. if yes, then first remove it and after that i create backup file
rup28aug@yahoo.co.in Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) My Company Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11