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

153 Comments

1. Tejaswini August 8, 2009

   Thanks for the solution.. 🙂
2. hussain August 11, 2009

   thank u very very much
3. Antony October 28, 2009

   Thanks a lot..
4. Raja November 17, 2009

   Thank u …God Bless you…
5. Eswar November 17, 2009

   Thnaks….
6. shameer November 23, 2009

   thankyou so muchhhhhhhhhhh
7. Rushi February 5, 2010

   This process of giving answers (with images) is so nice.
   Thanks for the solution.
8. Oleg February 6, 2010

   It’s great!!!
   Thank you
9. renzo varrone February 16, 2010

   Te amo sos un groso
   desde Argentina Entre Rios , Parana

   TE AMOOOOOOOOOOOO
10. xenia February 19, 2010

    ohhhh I will marry you!!!! tnx sooo much!!!!
11. kerem February 19, 2010

    thanks buddy..good point
12. Carlos D February 24, 2010

    This is a great solution. Keep up the great work and thanks a bunch!!!

    Carlos D.
13. Siraj February 24, 2010

    Its working. thanks
14. Pradp March 17, 2010

    great…works fine for me
15. Grey March 23, 2010

    Thanks a lot, this post helped me
16. JAaronAndersondotcom March 29, 2010

    This would work if an existing database did NOT use the same .mdf file of another database that is currently driving the LIVE IIS webpages… how to I work with this situation?
17. Sam April 13, 2010

    JAaronAndersonDotcom…I had the same problem…try using the “Restore Database…” option under the “Databases” folder in the Microsoft SQL Server Management Studio IDE. Select the backup file in the “From Device…” option and type in the database name you want it to create. Also, make sure under the “Options” section that the “Restore As” file paths under the “Restore the database file as:” section are valid paths, otherwise, it will fail. You can also select the “Overwrite the existing database” option as well but I don’t think it is necessary. Hope this helps!
18. Dee April 29, 2010

    I have tried all instructions but still gives the same error for database set,

    Please assist asap, i am very desperate
19. Emmanuel May 6, 2010

    Thanks alot……you are so going to heaven!
20. Bobby May 11, 2010

    Thank you very much, worked like a charm.
21. jeet May 18, 2010

    No dude this answer dint work for me i got another error saying operating system error 5 !!!
22. linglom May 20, 2010

    Hi, Jeet
    Operating system error 5 is about permission issue. Check if you have enough permission.
23. Dee May 21, 2010

    ERROR 3154,

    PLEASE ASSIST ASAP
24. linglom June 7, 2010

    Hi, Dee
    Couldn’t you solve the problem by follow this post?
25. praveena June 30, 2010

    thank u very much…great job..
26. Pingback: The backup set holds a backup of a database other than the existing ‘dbName’ database « Venkatarr's Blog July 3, 2010
27. topsy August 2, 2010

    you are just too much
28. subba reddy August 4, 2010

    Nice explanation
29. Praveen August 9, 2010

    Thanks!!!
30. Alex August 12, 2010

    Muchas gracias!
    Спасибо большое )
31. kuldeep August 26, 2010

    thxxxx…………
32. aldux September 2, 2010

    You saved my life….
33. pegan September 3, 2010

    Thank you so much . =D
34. thiyaga October 31, 2010

    Thank you so much… Thank you Thank you…
35. Chong GC November 22, 2010

    Thanks for the solution. You had solved my problem that I had stuck for weeks. =D
36. Swapna November 29, 2010

    Thanks a lottttt…….
    problem solved in sec…..
37. thuzar December 3, 2010

    Great! Thanks for ur solution! It works fine for me…:)
38. Deepak December 15, 2010

    Great solution…!
    Thanks!
39. Mylo December 15, 2010

    Thank YOU!!!
40. shox December 23, 2010

    Thank you very much it works
41. asif December 28, 2010

    Thankyou very much………….
42. Subba Reddy January 10, 2011

    Thank you dude. your solution is very help me.
43. Sardar Waqas Ahmed January 21, 2011

    Thanks dear good answer to the post thanks you so much
44. JhonMilla February 2, 2011

    eres un capo hermano muchas gracias
45. christina February 11, 2011

    Thank you it worked.:)
46. Toto James February 18, 2011

    Thanks a lot. It has solved my problem
    Asante Sana……thanks again
47. vinay February 22, 2011

    simply awesome answer….
48. Roshani Panchal March 7, 2011

    Thanx for the solution..Just marking Overwrite checkbox solved my problem..thanx for the screen shot
49. poonam tiwari March 15, 2011

    thanx…
50. Sachin Warke March 17, 2011

    Thank You!
    It worked, the .bak files got restored properly.
51. Rash March 18, 2011

    Thank You.
    Your solution solved my problem.Thanks again.
52. Venkat919 April 10, 2011

    Hello Dude…

    Thanks for your article
    I solved my problem with the help of your article.

    Thanks & Regards
    Venkat
53. Karthik April 12, 2011

    Hello,

    Thanks for your post. Looks like Im missing out some settings/permissions. I am facing operating system error 3 as below. Any suggestions is well appreciated.

    ” System.Data.SqlClient.SqlError: The operating system returned the error ‘3(error not found)’ while attempting ‘CreateFile’ on ‘C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\” ..

    Cheers,
    Karthik
54. Hamid Khaksar July 31, 2011

    Tnx alot. u solved a big problem
55. Mohsin Khan August 13, 2011

    thanks a lot
56. Parikshit August 15, 2011

    Thanks a lot, brother.
57. Rajkumar August 23, 2011

    excellent
58. Muhammad Hussain September 21, 2011

    Great great and great. Soooooooooooo much thank you.
    Allah(God) Bless you
59. Ganesh October 11, 2011

    Thanks a lot… Very useful solution
60. Irene October 31, 2011

    Thanks!! 🙂
61. Viru October 31, 2011

    Thanks…it helped!
62. Chir@g November 2, 2011

    Thanks Buddy !!
63. MMU November 5, 2011

    Thanks a 1000 Buddy! Blessings.
64. MSMS November 6, 2011

    Thanks.
65. Joan November 9, 2011

    You rock man! 🙂
    Thanks!
66. Rtw November 11, 2011

    thanks… feel silly though.
67. ClubSlice November 12, 2011

    So simple, yet effective. Deleting the database was the solution. Thanks!
68. Adem HUR November 15, 2011

    Thanks a lot.
    You are great
69. Ralph December 8, 2011

    Thank you ALL for the posting. This information has lead me in the right direction and I finally got my database where it needs to be.
70. Rajendra December 13, 2011

    Thank you so much. your solution works fine…
71. Rubens Mariuzzo (@rmariuzzo) December 14, 2011

    Thanks for your explanation of the problem and solution.
72. Ashraf December 15, 2011

    Thank you very much, great solution 🙂
73. chagy December 18, 2011

    Thank you very much
74. DC December 22, 2011

    Thanks a ton… I have been trying for this since last 2 days… Thanks a lot for ur solution 🙂
75. Krishna December 27, 2011

    Best, keep it continue
76. Ajeesh January 28, 2012

    Thanks
77. honttz February 1, 2012

    THANKS MAN! 😀
78. Sandeep February 8, 2012

    Thank you man!! It solved my prblem.
79. Felipe February 15, 2012

    Thanks, Gracias.
    We will use your solution
    Have a good one!
80. christian February 18, 2012

    Thanks it works!
    God Bless You!
81. Ramesh Guptha February 28, 2012

    Thanks its working fine..
82. Felipe February 29, 2012

    Thanks its working fine !!!
83. Mr X March 22, 2012

    tkss 🙂
84. PankajKalra April 5, 2012

    Thanks yr maja aa gya

    very thnks
85. Poetry April 6, 2012

    Magnificent web site. Plenty of useful information here. I am sending it to some friends ans additionally sharing in delicious. And naturally, thanks to your effort!
86. rick April 16, 2012

    Thanks a lot! keep it up, man
87. ZiMM April 19, 2012

    Thank You!!!
88. Ajay April 26, 2012

    Thanks a lot my problem solved
89. mikki April 27, 2012

    Thank you!
    Спасибо!
90. Sachin Deshmukh April 27, 2012

    Thanks. It worked
91. Rafo May 17, 2012

    Thaaaank youuuu very very mmuch much :)_
92. shaquille May 22, 2012

    thanks
93. bilal May 22, 2012

    thanks ! it works !
94. charlyy May 23, 2012

    thanks (y)
95. Ian June 13, 2012

    This one rocks! TY ^_^
96. Prady June 15, 2012

    Thanks! It helped
97. bzlom June 19, 2012

    Thank you, being a newbie myself in MSSQL- this article really helped 🙂
98. Jen June 22, 2012

    Thanks!!! 🙂
99. KR July 4, 2012

    Thanks a lot! it helped a lot
100. Costa July 6, 2012

     BIG THANKS FOR U BRO…
101. vedant July 24, 2012

     thanx
102. Sankalpa August 6, 2012

     thank you
103. samane August 21, 2012

     Tnk alot .U sole My solution dear 🙂
104. Abhi August 23, 2012

     still having issues, solved my problem once, but when i again tried this with my new database, problem persists. Help me asap.
105. Lijo George August 23, 2012

     Thank you very much for the solution 🙂
106. Shakir Shabbir August 27, 2012

     Solution WorkS!
107. Jitendra Jariwala September 4, 2012

     Thank you very much….!
108. Vinay September 17, 2012

     Thanks a lot…:-) It helped me..:-)
109. Rajesh October 7, 2012

     Thanks a lot and this helped me a lot 🙂
110. appu October 18, 2012

     it works………thnx
111. jon October 22, 2012

     Still failed. appears error: ‘system.data.sqlclient.sqlerror:the backup set holds a backup ofn a database other than the existing ‘name_database’ database.(microsoft.sqlserver.smo)’
     Restore from .bak sql server 2000 to 2005.
112. wirawan khadafi October 30, 2012

     thanks a lot. it works,,,,,,,,
113. Fero November 1, 2012

     thanks a lot. it works and saved a lots of time… Keep up the good work…. You kind of geeks are always needed by us…
114. Ranjith V November 7, 2012

     Thankz a lot…
115. Avianash November 8, 2012

     This process of giving answers (with images) is so nice.

     Thanks for the solution.
116. vergil December 12, 2012

     thank you so much….
117. Krashan December 19, 2012

     ThX.. it’s saved my ass 🙂
118. Raquel December 27, 2012

     Bom dia a todos.
     Eu já tinha realizado todos esses procedimentos. De substituir e a mensagem continua.
     Sei que esta utilizando algum arquivo que nao esta me permitindo mas como resolver isso? Já parei todos os serviços q poderia estar utilizando o bando de dados que quero copiar e mesmo assim nada.
     Alguém tem alguma outra sugestão?
     Obrigada.
119. Ahmad Hassan January 1, 2013

     hello everyone, I get a strange error it says system.data.sqlclient.sqlerror: The media set has two media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Smo).
     Can anyone please help me out with that????
120. Ahmad Hassan January 1, 2013

     Sorry for inconvenience guys. I have solved my problem.
121. Aguirre January 3, 2013

     Thanks dude!
122. Vergel February 4, 2013

     Thank you very much
123. ankit February 18, 2013

     ohhhhh thank god bro. u really helped me by giving that solution. Thanks again
124. parsha February 19, 2013

     thankyou n God Bless
125. Tracy March 7, 2013

     Thanks you, finally able to solve my problem.
126. Lahiru April 10, 2013

     Thanks sir… You save my time… Thanks
127. Sandy April 25, 2013

     Thank you very much!!
128. Bhagyashree April 30, 2013

     thanks
129. Sharath May 3, 2013

     Thanks a lot
130. Peppe August 9, 2013

     a big “grazie mille” for your simple and effective answer – saluti from Switzerland 🙂
131. Gege October 16, 2013

     Thanks
132. Raghav November 5, 2013

     When im restoring ..at 90% i got below error.
     The file on device — is not a valid Microsoft Tape Format backup set.
133. hamed November 11, 2013

     Thanks alot.
     realy thanks.
134. christian November 27, 2013

     Thanks you mate!! te amo!!! me puedes hacer un hijo?? o mejor q sean dos, para tener la parejita
135. Raj December 6, 2013

     Hey…thanks….its working fine for me 🙂
136. raj January 16, 2014

     thanks duuuuuude ………… 🙂
137. himanshu Rana January 30, 2014

     thank you now i am really happy.bcoz i just face this problem from last 5 days.
     thankx a lot…
138. Pingback: The backup set holds a backup of a database other than the existing ‘DB Name’ database. | madhavan June 23, 2014
139. ifelere July 22, 2014

     Funny that I have just come across this issue. Thanks a million!
140. Nabil June 20, 2015

     thanks a lot 🙂
141. Dominic July 14, 2015

     This is awesome. Thanks for the solution
142. praveen July 31, 2015

     thanks for your wonderful solution keep it up
143. Anush September 9, 2015

     Thank you so much and it looks so simple when I followed your instructions.
144. Kashan Mirza October 27, 2015

     Thank you 🙂
145. Sudhindra November 24, 2015

     Thank you ……
146. Sudheer Kumar Verma January 11, 2016

     Thank you so much it really worked 🙂
147. Shrikrishna Das January 11, 2016

     Thanks a lot for this Great solution.
148. Hayat March 31, 2016

     Thanks alot
149. akash April 23, 2016

     thanks…
150. akash April 23, 2016

     thanks
151. Jesús Manuel July 4, 2016

     Excelente respuesta, me sirvió.
152. priyancy July 16, 2016

     It’s great solution !!!
     Thank you…..
153. swamy December 13, 2016

     iam trying your telled process but again error is coming like this

     system.data.sqlclient.sqlerror:Directory lookup for the file
154. Veera Sareddy February 26, 2017

     Thanks alot.. Works charm.
155. Komla November 17, 2021

     You are a life saver!
     IT WORKED PERFECTLY!!!