[Solved] System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing ‘dbName’ database

You have backup a database on SQL Server 2005. Then, you try to restore the backup file on an existing database and receive the error message below:

Restore failed for Server ‘SQL Server name‘. (Microsoft.SqlServer.Smo)
Additional information:
System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing ‘dbName‘ database. (Microsoft.SqlServer.Smo)
The backup set holds a backup of a database other than the existing

This error message indicates that you are going to restore a database on another database which are not the same database. For example, you have backup Northwind database and try to restore the backup to AdventureWorks database, the error will occur.

Solution

To solve the problem, you can use the overwrite the existing database option while you’re restoring.

  1. On Restore Database, select Options tab on the left menu. Then, check Overwrite the existing database on Restore options.
    Note: This option will overwrite any existing data on the targeted database.
    Restore Database Option
  2. Try to restore the database, the problem should be gone now.
    Restore Database Successful

Note: you can also delete the targeted database before perform restore a database. This way also gives the result as same as the solution above.

152 Comments

  1. Tejaswini August 8, 2009
  2. hussain August 11, 2009
  3. Antony October 28, 2009
  4. Raja November 17, 2009
  5. Eswar November 17, 2009
  6. shameer November 23, 2009
  7. Rushi February 5, 2010
  8. Oleg February 6, 2010
  9. renzo varrone February 16, 2010
  10. xenia February 19, 2010
  11. kerem February 19, 2010
  12. Carlos D February 24, 2010
  13. Siraj February 24, 2010
  14. Pradp March 17, 2010
  15. Grey March 23, 2010
  16. JAaronAndersondotcom March 29, 2010
  17. Sam April 13, 2010
  18. Dee April 29, 2010
  19. Emmanuel May 6, 2010
  20. Bobby May 11, 2010
  21. jeet May 18, 2010
  22. linglom May 20, 2010
  23. Dee May 21, 2010
  24. linglom June 7, 2010
  25. praveena June 30, 2010
  26. topsy August 2, 2010
  27. subba reddy August 4, 2010
  28. Praveen August 9, 2010
  29. Alex August 12, 2010
  30. kuldeep August 26, 2010
  31. aldux September 2, 2010
  32. pegan September 3, 2010
  33. thiyaga October 31, 2010
  34. Chong GC November 22, 2010
  35. Swapna November 29, 2010
  36. thuzar December 3, 2010
  37. Deepak December 15, 2010
  38. Mylo December 15, 2010
  39. shox December 23, 2010
  40. asif December 28, 2010
  41. Subba Reddy January 10, 2011
  42. Sardar Waqas Ahmed January 21, 2011
  43. JhonMilla February 2, 2011
  44. christina February 11, 2011
  45. Toto James February 18, 2011
  46. vinay February 22, 2011
  47. Roshani Panchal March 7, 2011
  48. poonam tiwari March 15, 2011
  49. Sachin Warke March 17, 2011
  50. Rash March 18, 2011
  51. Venkat919 April 10, 2011
  52. Karthik April 12, 2011
  53. Hamid Khaksar July 31, 2011
  54. Mohsin Khan August 13, 2011
  55. Parikshit August 15, 2011
  56. Rajkumar August 23, 2011
  57. Muhammad Hussain September 21, 2011
  58. Ganesh October 11, 2011
  59. Irene October 31, 2011
  60. Viru October 31, 2011
  61. [email protected] November 2, 2011
  62. MMU November 5, 2011
  63. MSMS November 6, 2011
  64. Joan November 9, 2011
  65. Rtw November 11, 2011
  66. ClubSlice November 12, 2011
  67. Adem HUR November 15, 2011
  68. Ralph December 8, 2011
  69. Rajendra December 13, 2011
  70. Rubens Mariuzzo (@rmariuzzo) December 14, 2011
  71. Ashraf December 15, 2011
  72. chagy December 18, 2011
  73. DC December 22, 2011
  74. Krishna December 27, 2011
  75. Ajeesh January 28, 2012
  76. honttz February 1, 2012
  77. Sandeep February 8, 2012
  78. Felipe February 15, 2012
  79. christian February 18, 2012
  80. Ramesh Guptha February 28, 2012
  81. Felipe February 29, 2012
  82. Mr X March 22, 2012
  83. PankajKalra April 5, 2012
  84. Poetry April 6, 2012
  85. rick April 16, 2012
  86. ZiMM April 19, 2012
  87. Ajay April 26, 2012
  88. mikki April 27, 2012
  89. Sachin Deshmukh April 27, 2012
  90. Rafo May 17, 2012
  91. shaquille May 22, 2012
  92. bilal May 22, 2012
  93. charlyy May 23, 2012
  94. Ian June 13, 2012
  95. Prady June 15, 2012
  96. bzlom June 19, 2012
  97. Jen June 22, 2012
  98. KR July 4, 2012
  99. Costa July 6, 2012
  100. vedant July 24, 2012
  101. Sankalpa August 6, 2012
  102. samane August 21, 2012
  103. Abhi August 23, 2012
  104. Lijo George August 23, 2012
  105. Shakir Shabbir August 27, 2012
  106. Jitendra Jariwala September 4, 2012
  107. Vinay September 17, 2012
  108. Rajesh October 7, 2012
  109. appu October 18, 2012
  110. jon October 22, 2012
  111. wirawan khadafi October 30, 2012
  112. Fero November 1, 2012
  113. Ranjith V November 7, 2012
  114. Avianash November 8, 2012
  115. vergil December 12, 2012
  116. Krashan December 19, 2012
  117. Raquel December 27, 2012
  118. Ahmad Hassan January 1, 2013
  119. Ahmad Hassan January 1, 2013
  120. Aguirre January 3, 2013
  121. Vergel February 4, 2013
  122. ankit February 18, 2013
  123. parsha February 19, 2013
  124. Tracy March 7, 2013
  125. Lahiru April 10, 2013
  126. Sandy April 25, 2013
  127. Bhagyashree April 30, 2013
  128. Sharath May 3, 2013
  129. Peppe August 9, 2013
  130. Gege October 16, 2013
  131. Raghav November 5, 2013
  132. hamed November 11, 2013
  133. christian November 27, 2013
  134. Raj December 6, 2013
  135. raj January 16, 2014
  136. himanshu Rana January 30, 2014
  137. ifelere July 22, 2014
  138. Nabil June 20, 2015
  139. Dominic July 14, 2015
  140. praveen July 31, 2015
  141. Anush September 9, 2015
  142. Kashan Mirza October 27, 2015
  143. Sudhindra November 24, 2015
  144. Sudheer Kumar Verma January 11, 2016
  145. Shrikrishna Das January 11, 2016
  146. Hayat March 31, 2016
  147. akash April 23, 2016
  148. akash April 23, 2016
  149. Jesús Manuel July 4, 2016
  150. priyancy July 16, 2016
  151. swamy December 13, 2016
  152. Veera Sareddy February 26, 2017

Leave a Reply