Linglom.com

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

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

1. Tejaswini Says:
   August 8th, 2009 at 12:51 pm

   Thanks for the solution..

2. hussain Says:
   August 11th, 2009 at 7:46 am

   thank u very very much

3. Antony Says:
   October 28th, 2009 at 11:34 am

   Thanks a lot..

4. Raja Says:
   November 17th, 2009 at 5:04 pm

   Thank u …God Bless you…

5. Eswar Says:
   November 17th, 2009 at 7:27 pm

   Thnaks….

6. shameer Says:
   November 23rd, 2009 at 8:39 pm

   thankyou so muchhhhhhhhhhh

7. Rushi Says:
   February 5th, 2010 at 1:34 pm

   This process of giving answers (with images) is so nice.
   Thanks for the solution.

8. Oleg Says:
   February 6th, 2010 at 4:42 am

   It’s great!!!
   Thank you

9. renzo varrone Says:
   February 16th, 2010 at 8:36 am

   Te amo sos un groso
   desde Argentina Entre Rios , Parana

   TE AMOOOOOOOOOOOO

10. xenia Says:
    February 19th, 2010 at 1:37 am

    ohhhh I will marry you!!!! tnx sooo much!!!!

11. kerem Says:
    February 19th, 2010 at 5:17 am

    thanks buddy..good point

12. Carlos D Says:
    February 24th, 2010 at 4:44 am

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

    Carlos D.

13. Siraj Says:
    February 24th, 2010 at 2:37 pm

    Its working. thanks

14. Pradp Says:
    March 17th, 2010 at 4:43 am

    great…works fine for me

15. Grey Says:
    March 23rd, 2010 at 6:12 pm

    Thanks a lot, this post helped me

16. JAaronAndersondotcom Says:
    March 29th, 2010 at 9:00 pm

    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 Says:
    April 13th, 2010 at 1:32 am

    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 Says:
    April 29th, 2010 at 1:34 pm

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

    Please assist asap, i am very desperate

19. Emmanuel Says:
    May 6th, 2010 at 6:41 pm

    Thanks alot……you are so going to heaven!

20. Bobby Says:
    May 11th, 2010 at 11:30 pm

    Thank you very much, worked like a charm.

21. jeet Says:
    May 18th, 2010 at 3:18 am

    No dude this answer dint work for me i got another error saying operating system error 5 !!!

22. linglom Says:
    May 20th, 2010 at 9:12 pm

    Hi, Jeet
    Operating system error 5 is about permission issue. Check if you have enough permission.

23. Dee Says:
    May 21st, 2010 at 7:55 am

    ERROR 3154,

    PLEASE ASSIST ASAP

24. linglom Says:
    June 7th, 2010 at 10:56 am

    Hi, Dee
    Couldn’t you solve the problem by follow this post?

25. praveena Says:
    June 30th, 2010 at 5:50 pm

    thank u very much…great job..

26. The backup set holds a backup of a database other than the existing ‘dbName’ database « Venkatarr's Blog Says:
    July 3rd, 2010 at 10:09 am

    [...] have backup a database on SQL Server 2005. Then, you try to restore the backup file on an existing database and receive [...]

27. topsy Says:
    August 2nd, 2010 at 9:02 pm

    you are just too much

28. subba reddy Says:
    August 4th, 2010 at 7:04 pm

    Nice explanation

29. Praveen Says:
    August 9th, 2010 at 1:10 pm

    Thanks!!!

30. Alex Says:
    August 12th, 2010 at 9:05 pm

    Muchas gracias!
    Спасибо большое )

31. kuldeep Says:
    August 26th, 2010 at 12:46 am

    thxxxx…………

32. aldux Says:
    September 2nd, 2010 at 9:10 pm

    You saved my life….

33. pegan Says:
    September 3rd, 2010 at 9:43 am

    Thank you so much . =D

34. thiyaga Says:
    October 31st, 2010 at 11:26 am

    Thank you so much… Thank you Thank you…

35. Chong GC Says:
    November 22nd, 2010 at 2:03 am

    Thanks for the solution. You had solved my problem that I had stuck for weeks. =D

36. Swapna Says:
    November 29th, 2010 at 2:12 pm

    Thanks a lottttt…….
    problem solved in sec…..

37. thuzar Says:
    December 3rd, 2010 at 3:27 pm

    Great! Thanks for ur solution! It works fine for me…:)

38. Deepak Says:
    December 15th, 2010 at 2:38 am

    Great solution…!
    Thanks!

39. Mylo Says:
    December 15th, 2010 at 3:10 am

    Thank YOU!!!

40. shox Says:
    December 23rd, 2010 at 6:39 am

    Thank you very much it works

41. asif Says:
    December 28th, 2010 at 12:22 pm

    Thankyou very much………….

42. Subba Reddy Says:
    January 10th, 2011 at 10:28 pm

    Thank you dude. your solution is very help me.

43. Sardar Waqas Ahmed Says:
    January 21st, 2011 at 9:24 pm

    Thanks dear good answer to the post thanks you so much

44. JhonMilla Says:
    February 2nd, 2011 at 4:23 am

    eres un capo hermano muchas gracias

45. christina Says:
    February 11th, 2011 at 2:26 pm

    Thank you it worked.:)

46. Toto James Says:
    February 18th, 2011 at 10:30 am

    Thanks a lot. It has solved my problem
    Asante Sana……thanks again

47. vinay Says:
    February 22nd, 2011 at 11:54 pm

    simply awesome answer….

48. Roshani Panchal Says:
    March 7th, 2011 at 1:03 pm

    Thanx for the solution..Just marking Overwrite checkbox solved my problem..thanx for the screen shot

49. poonam tiwari Says:
    March 15th, 2011 at 2:40 pm

    thanx…

50. Sachin Warke Says:
    March 17th, 2011 at 2:48 pm

    Thank You!
    It worked, the .bak files got restored properly.

51. Rash Says:
    March 18th, 2011 at 10:26 pm

    Thank You.
    Your solution solved my problem.Thanks again.

52. Venkat919 Says:
    April 10th, 2011 at 7:27 pm

    Hello Dude…

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

    Thanks & Regards
    Venkat

53. Karthik Says:
    April 12th, 2011 at 12:19 am

    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 Says:
    July 31st, 2011 at 4:58 pm

    Tnx alot. u solved a big problem

55. Mohsin Khan Says:
    August 13th, 2011 at 11:48 am

    thanks a lot

56. Parikshit Says:
    August 15th, 2011 at 5:03 am

    Thanks a lot, brother.

57. Rajkumar Says:
    August 23rd, 2011 at 6:07 pm

    excellent

58. Muhammad Hussain Says:
    September 21st, 2011 at 3:09 am

    Great great and great. Soooooooooooo much thank you.
    Allah(God) Bless you

59. Ganesh Says:
    October 11th, 2011 at 7:53 pm

    Thanks a lot… Very useful solution

60. Irene Says:
    October 31st, 2011 at 10:26 am

    Thanks!!

61. Viru Says:
    October 31st, 2011 at 12:22 pm

    Thanks…it helped!

62. Chir@g Says:
    November 2nd, 2011 at 6:46 pm

    Thanks Buddy !!

63. MMU Says:
    November 5th, 2011 at 12:13 am

    Thanks a 1000 Buddy! Blessings.

64. MSMS Says:
    November 6th, 2011 at 2:43 am

    Thanks.

65. Joan Says:
    November 9th, 2011 at 8:56 pm

    You rock man!
    Thanks!

66. Rtw Says:
    November 11th, 2011 at 1:10 am

    thanks… feel silly though.

67. ClubSlice Says:
    November 12th, 2011 at 7:52 am

    So simple, yet effective. Deleting the database was the solution. Thanks!

68. Adem HUR Says:
    November 15th, 2011 at 12:27 am

    Thanks a lot.
    You are great

69. Ralph Says:
    December 8th, 2011 at 3:41 am

    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 Says:
    December 13th, 2011 at 12:25 pm

    Thank you so much. your solution works fine…

71. Rubens Mariuzzo (@rmariuzzo) Says:
    December 14th, 2011 at 11:34 pm

    Thanks for your explanation of the problem and solution.

72. Ashraf Says:
    December 15th, 2011 at 10:17 pm

    Thank you very much, great solution

73. chagy Says:
    December 18th, 2011 at 10:39 am

    Thank you very much

74. DC Says:
    December 22nd, 2011 at 1:29 am

    Thanks a ton… I have been trying for this since last 2 days… Thanks a lot for ur solution

75. Krishna Says:
    December 27th, 2011 at 1:36 pm

    Best, keep it continue

76. Ajeesh Says:
    January 28th, 2012 at 5:18 pm

    Thanks

77. honttz Says:
    February 1st, 2012 at 8:16 am

    THANKS MAN!

Leave a Reply