SQL Server Journey with SQL Authority

Posted in Pinal Dave, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology | 52 Comments

52 Responses

1. on June 14, 2009 at 6:17 am | Reply Sean

   But what does SQL Server do? And will uninstalling it affect the performance of my computer or any programs in any way? If we can just uninstall it, why was it there in the first place?

   
   
2. on August 14, 2009 at 3:18 pm | Reply Steve

   Thanks for this advice, it was just what I was looking for. Have a good day.

   
   
3. on August 30, 2009 at 10:46 pm | Reply Re: Sean

   It’s a database program that sometimes comes preloaded on some systems. If you’re not doing anything with databases then you’re fine.

   
   
4. on October 22, 2009 at 6:59 am | Reply Emdad

   How do I reinstall SQL Server VSS writer?

   
   
5. on October 23, 2009 at 6:42 pm | Reply Ines

   Thank you for your help! Problem is solved. No more error messages.

   
   
6. on December 4, 2009 at 8:01 pm | Reply mrBlack

   What should I do if Remove “microsoft SQL server vss writer” program does not work? It asks for a msi file and I have no idea where to get it. Can you suggest some othe way to remove vss writer?

   
   
7. on December 6, 2009 at 2:57 pm | Reply Rick

   Thank you!
   This message has been driving me mad.

   I really appreciate your help.

   Take care,

   Rick

   
   
8. on December 6, 2009 at 10:11 pm | Reply purva

   sir,
   i just have uninstalled microsoft sql server VSS writer by mistake from my computer.i am worried does this would anyhow affect my computer or asp.net web development.please reply sir.i am too tensed.

   
   
9. on December 17, 2009 at 2:56 am | Reply A. Monaco

   That Fixed it…. I downloaded a trial of Microsoft Office 2007 and when the trial expired I removed it but not all of the files were removed with its removal option.

   Nothing like getting a trial that screws up your computer

   
   
   • on January 24, 2010 at 6:46 am | Reply Louise

     I think that is what happened to me too, because I started seeing this error window right after I tried to delete the trail version. Also, I can’t open my old versions of Word and Excel now without error messages. oh brother!

     
     
10. on December 29, 2009 at 4:54 pm | Reply mehdi

    thank you for your advice.

    
    
11. on January 13, 2010 at 7:46 pm | Reply Venkat

    hello sir,

    i found some error when drop one table that’s name HHCCustomer.when this table drop one error occure i.e Server: Msg 7105, Level 22, State 3, Line 1
    Page (1:63016), slot 0 for text, ntext, or image node does not exist.

    plz help me how to drop table.

    Regards,
    Venkat

    
    
12. on January 14, 2010 at 12:04 am | Reply dave

    thanks, brother…

    cheers!

    
    
13. on January 28, 2010 at 8:10 am | Reply Paul Williams

    Thanks alot, i was tried of the message.

    
    
14. on February 15, 2010 at 6:33 am | Reply Carol

    appreciate the advice- it worked

    
    
15. on March 7, 2010 at 12:55 pm | Reply T. Levin

    I tried to uninstall it, but I get an error message saying “Another installation is already in progress. Complete that installation before proceeding wtih this install.”

    
    
16. on March 9, 2010 at 2:37 am | Reply Gemma

    Thanks!!
    It works perfect.

    
    
17. on March 21, 2010 at 6:43 am | Reply Frederick

    How do I reinstall SQL Server VSS writer

    
    
18. on April 8, 2010 at 2:02 am | Reply Ammar

    I know this post is too old for someone to comment here and expect a response, but I couldn’t resist asking this question:-

    As far as I can see, this is no solution, this is removing the program that’s having a problem altogether, how about if I need SQL Writer to work ? what do I do ?

    
    
19. on June 22, 2010 at 7:30 pm | Reply Andrzej Wajler

    It’s been a while since last comment but actually Ammar has asked a good questions. How should I fix the problem if I need SQL Writer (for third party backup software that’s backing up database using VSS). Is it matter of reinstalling/repairing SQL Server VSS ?
    Cheers,
    Andrzej

    
    
20. on July 3, 2010 at 5:13 am | Reply Darrell

    Excellent. removed the ms sql vss writer, tested it 3 times and, gone. Thanks.

    
    
21. on July 16, 2010 at 10:07 pm | Reply Ron

    Ditto!

    How should I fix the problem if I need SQL Writer if I need SQL Writer ????

    “”"”"”"”"It’s been a while since last comment but actually Ammar has asked a good questions. How should I fix the problem if I need SQL Writer (for third party backup software that’s backing up database using VSS). Is it matter of reinstalling/repairing SQL Server VSS ?”
    “”"”"”"”"”"”"”"”"”"”

    
    
22. on July 30, 2010 at 9:50 pm | Reply Trey

    I agree. Is there a way to actually fix SQL server vss writer? If we need to remove it to get rid of the error message, how do we get it back. It is a necessary component for many servers.

    
    
23. on August 2, 2010 at 5:27 pm | Reply E. K.

    The Microsoft package uninstall/reinstall scripts really suck. Thank you for the good solution sir.

    
    
24. on November 11, 2010 at 5:29 pm | Reply V.S

    thnks 4 da solution bt hw wuld i reinstall da vss writer?

    
    
25. on November 12, 2010 at 12:32 am | Reply Sav

    Awesome . Great fix..Thanks

    
    
26. on November 12, 2010 at 5:48 am | Reply Richard Villiva

    Sean
    But what does SQL Server do? And will uninstalling it affect the performance of my computer or any programs in any way? If we can just uninstall it, why was it there in the first place?

    This was the first response and I would like to know tha answer to this.
    Thanks,
    Richard Villiva

    
    
27. on November 20, 2010 at 9:22 am | Reply Marshall

    Somehow this error is stopping my desktop from booting all the way. I can’t even get to the add/remove programs. My mouse moves on the screen, the keyboard in unresponsive (but works if I hit f2 or f12 at boot up.) I could get to the processes window, but no icons or start menu is visible.

    
    
28. on November 24, 2010 at 9:55 pm | Reply kevin

    How do I download and reinstall” Microsoft SQL vss writer”
    Thank you.
    Kevin

    
    
29. on January 17, 2011 at 12:08 am | Reply Resko24

    thanx. problem solved … ur the best man … !

    
    
30. on January 23, 2011 at 1:20 am | Reply Alex

    Thank you for the solution. I am an electrical engineer and I live in Brazil Latin America.

    
    
31. on January 25, 2011 at 2:36 am | Reply Trey

    How do we go about reinstalling the VSS writer? It appears that MoxyPro needs this to work.

    
    
32. on February 15, 2011 at 3:53 pm | Reply Phil Turtle

    This is not a solution.
    If you get a problem with Word do you uninstall that?

    
    
33. on March 7, 2011 at 11:07 pm | Reply Diablo

    Well nobody wants to answer “What is SQL dumper?”
    After a little searching i found the info below.
    For better understanding of the SQL dumper, please visit the msdn page:
    http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/b1a5600c-8fd2-4f49-a3e7-8b058e2ce09b
    What it means basically is that SQL dumper is a debug program for SQL. You can get it back by reinstalling SQL server.

    
    
34. on March 15, 2011 at 5:26 pm | Reply Karen

    Thanks so much, your solution was simple and perfect.

    
    
35. on April 27, 2011 at 12:11 pm | Reply Jules

    Thanks so much for this thread. My problem fixed easy without disrupting or damaging other programs in my compter. And more importantly, no more worrying message (for a non-tech person like me).

    Thanks also for the convincing explanation that uninstalling the SQLDUMPER is safe for those who do not need this program – and I suspect this would be the majority of lay-users :-)

    Jules – Indonesia

    
    
36. on May 2, 2011 at 6:18 pm | Reply Shahin babu

    How do I reinstall SQL Server VSS writer

    
    
37. on May 21, 2011 at 8:12 pm | Reply Joy Galindo

    I can only get the computer to the Windows XP screen and then I press Alt, Control, Delete and then the error screen comes on. My bookeeper says she was able the just press “OK” and then the programs would come up. But nothing happens at all from there for me. How would I get to the Window Control Panel when I can’t get out of the Error Box?

    
    
38. on August 2, 2011 at 2:10 pm | Reply Neo3998

    RE: “thnks 4 da solution bt hw wuld i reinstall da vss writer?”

    Maybe you should not touch a PC/server, let alone SQL/services until you learn how to write a sentence!

    
    
39. on August 9, 2011 at 3:26 pm | Reply Ravinder

    Dear Sir,
    I have uninstall the vss writer and error get resolved but i wants to know that it may effect on preformance or not .

    Early response with appropriated .

    Warm Regards
    Ravinder Singh Rana.

    
    
40. on August 12, 2011 at 10:55 pm | Reply Bola S.

    Hi,
    Am having an error

    “CmdImportDatabase()[Microsoft][ODBC SQL Server Driver][SQL Server]Database ‘Net2′ cannot be upgraded because it is read-only or has read-only files. Make database or files writeable, and rerun recovery.
    [Microsoft][ODBC SQL Server Driver][SQL Server] could not open new database ‘Net2′. CREATE DATABASE is aborted.(0x80040D57)

    when loading a database back into an application. Kindly help me to see if there is a solution for this.

    Regards,

    Bola

    
    
41. on August 26, 2011 at 2:25 pm | Reply John

    Thanks for that it workied on a clients PC who was having the same error

    
    
42. on November 22, 2011 at 9:22 am | Reply Joe

    I’ll be the 10th or 12th person to ask this obvioius question: Where do I get the link to re-install SQL VSS Server Writer? Anyone? Thank you.

    
    
43. on December 13, 2011 at 10:40 pm | Reply skyambler

    Windows XP – When you go to control panel-add remove programs. You will see the MICROSOFT SERVER SQL VSS WRITER. Instead of uninstalling if you click on “change” it will give you the option to repair it and it will reinstall it.

    
    
    • on November 1, 2012 at 5:26 pm | Reply SunCloud7

      Thank you for this ‘skyambler’! We asked the obvious question too: “how do I mend it rather than removing it?” and your answer was easy to follow and worked. Fab.

      
      
44. on February 11, 2012 at 3:23 pm | Reply Gheorghe Iftimi

    Thanks for this thread! God be with you!

    
    
45. on February 23, 2012 at 8:48 am | Reply Ann

    Thank you -Thank you- Thank you.-For everyone’s input. Bought Microsoft Office 2007 and got this bug with it–now I can fix it.

    
    
46. on April 23, 2012 at 11:05 pm | Reply Benjamin Breeg

    For those of you (Xp users) who wish to remove the message, but who are also worried about uninstalling your sqldumper:

    1. Open control panel -
    2. Click on administrative tools
    3. Click on services
    4. scroll down to SQL Server VSS Writer, double click on it.
    5. Change starttype setting from “automatic” to “manual”

    
    
47. on June 13, 2012 at 8:41 am | Reply Tom Millar

    Benjamin, kudos. That was the most elegant solution posted!

    
    
48. on July 30, 2012 at 9:19 pm | Reply MrDraco

    I am not a big fan of disabling or worse uninstalling an application/service when I don’t completely understand its purpose/function. Therefore, I would suggest that you do what I did on my Windows Server 2003 Standard Edition SP2 Domain Controller that is also our company’s BlackBerry Enterprise Server, and repair the Microsoft SQL Server VSS Writer using the following:

    1. Open Control Panel
    2. Open Add and Remove Programs
    3. Select Microsoft SQL Server VSS Writer and click on the Change button
    4. Click the Next button at the Setup Wizard Welcome screen
    5. Select the Repair option and click the Next button
    6. Once the Repair process completes, Exit the Setup Wizard

    Note: In my case, a reboot wasn’t even required.

    I hope this helps someone.

    
    
49. on January 9, 2013 at 10:22 pm | Reply LesleyS

    Ben – thank you! Changing from automatic to manual in services has fixed the startup error without having to uninstall a program that I may not have the ability to reinstall if it proves needed by other programs.

    
    
50. on March 9, 2013 at 3:50 pm | Reply suresh

    sql server setup has encountered the following error:

    MsiGetProduct Failed To retrive ProductVersion for package with product code={72DE3C67-FB48-450E-8BEA-4EB13B53355D}’ Error Code:1608

    Hi Pinal Sir,

    when i am installing sql server R2 in my pc ,i am getting this type of error.i can’t understand why it show…..

    Please Help Me Sir…….

    
    

Leave a Reply Cancel reply

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Cancel

Connecting to %s

Notify me of follow-up comments via email.

Notify me of new posts via email.