locked
Missing SQL VSS Writer RRS feed

  • Question

  • Hi

    We have a server running SQL 2008R2

    Since a couple of weeks the SQL VSS Writer is not present in the list shown by running "vssadmin list writers"

    We have tried to restart the SQL VSS Writer service several times.

    There are no DBs with space in their name

    No errors or regarding information in Event Log

    We have also rebooted the server.

    We have another server with the same configuration and DBs which does not have this issue.

    Any suggestion?
    Tuesday, July 26, 2011 7:22 AM

Answers

  • I just resolved the same issue.

    Please run the query : - select '#' + name +'#'  from sys.databases

     

    the issue was found to be due to spaces in the databases name.

     

     


    Harsh Chawla Personal Blog:- http://blogs.msdn.com/batala Team Blog:- http://blogs.msdn.com/b/sqlserverfaq/
    • Marked as answer by _Mic Monday, August 1, 2011 11:43 AM
    Thursday, July 28, 2011 4:40 PM

All replies

  • Do you see SQL server vss writer service for SQL ? Could you please check if thats started?

     


    Harsh Chawla Personal Blog:- http://blogs.msdn.com/batala Team Blog:- http://blogs.msdn.com/b/sqlserverfaq/
    Tuesday, July 26, 2011 8:32 AM
  • Yes it's started
    Tuesday, July 26, 2011 9:39 AM
  • Could you please check if  NT AUTHORITY\SYSTEM is added in sql server under security ? and also try to change the login to local system and check if that helps.
    Harsh Chawla Personal Blog:- http://blogs.msdn.com/batala Team Blog:- http://blogs.msdn.com/b/sqlserverfaq/
    Tuesday, July 26, 2011 9:52 AM
  • yes NT AUTHORITY\SYSTEM has a login on SQL and is sysadmin

    The service already runs as Local System

    Tuesday, July 26, 2011 9:57 AM
  • I have seen normally the access rights to be the issue in such scenarios. Could you please check event Application logs once again, there should definately be some errors.

     

     

     

     


    Harsh Chawla Personal Blog:- http://blogs.msdn.com/batala Team Blog:- http://blogs.msdn.com/b/sqlserverfaq/
    Tuesday, July 26, 2011 11:38 AM
  • Hi ,

    Please try the following steps to trouble shoot:

    1. Create a SQL Trace with Profiler and connect to the SQL Instance for the server with this problem.
    2 .Add the entire Errors and Warnings object set to the trace.
    3. Add Audit Login Failed Event to the trace.
    4. Remove everything but the above from the trace.
    5. Start the trace
    6. Try and Start the VSS Writer.
    See what errors pop inside the trace while it attempts to start and fails.  If you have more than one SQL Instance on this server, repeat the above for each instance.  See if something pops up in the trace.  Check and see if the SQL Writer service account has access to the SQL instances.  When checking the Server Logs in Windows, you should be looking under the System Log which should show startup/stop information for the service.

    And you could also try to reinstall the SQL Server VSS Writer:

    1. In Add Remove Programs, uninstall the SQL Server VSS Writer.
    2. Restart the server after removing the installed component to  clear the loaded registy values and or DLL's.
    3. From your SQL Server  Installation media, open the Tools\Setup folder and run the SqlWriter.msi file.
    4. Reapply any CUs or SPs
    5. Reboot the Server again
    6. See if it starts properly.

    Hope this helps.


    Best Regards,
    Peja

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Thursday, July 28, 2011 2:09 AM
  • I just resolved the same issue.

    Please run the query : - select '#' + name +'#'  from sys.databases

     

    the issue was found to be due to spaces in the databases name.

     

     


    Harsh Chawla Personal Blog:- http://blogs.msdn.com/batala Team Blog:- http://blogs.msdn.com/b/sqlserverfaq/
    • Marked as answer by _Mic Monday, August 1, 2011 11:43 AM
    Thursday, July 28, 2011 4:40 PM
  • thanks for that Harsh!

    the space was at the end of the name and could not see it!

    "MydatabaseName "

    Using the # helped!


    wait for the DB guys to change the name and will test if VSS is there
    Thursday, July 28, 2011 10:44 PM
  • Hi Harsh,

    I have even checked for the database names and there is no white space. But still SQL Server Writer is missing in the list of VSS Admin.

    What can be checked next to resolve this. Please suggest.

    Aakash


    Aakash Saxena

    Thursday, October 6, 2016 10:28 AM