none
ERROR: SQL Backup task failed. Error message - SQL Writer not found

    Question

  • Hi

    I am getting ERROR: SQL Backup task failed. Error message - SQL Writer not found error in SMSBkup.log.

    I have ConfigMgr 2007 SP2 ,SQL server 2008 sp1,WIndows 2008 R2. Configmgr Database is hosted on other server

    My observations-

    1. VSSadmin list writers shows

        Writer name: 'SMS Writer'
       Writer Id: {03ba67dd-dc6d-4729-a038-251f7018463b}
       Writer Instance Id: {fcc61cc0-41f4-4529-bf6c-2c4674432f94}
       State: [7] Failed
       Last error: Timed out

    2. As per various post,

      I tried installing KB981640 on Primary server and then copied updated smsqlbkup.exe to database server.

      Also edited Install.map ie

      BEGIN_COMPONENT_FILELIST
        <SMS_SITE_BACKUP>
        <537>
        BEGIN_DIRECTORY
            <bin\i386>
            <9><X86><>
            FILE <smsbkup.exe><1><106496>
        END_DIRECTORY
        BEGIN_DIRECTORY
            <bin\x64>
            <17><AMD64><>
            FILE <smsbkup.exe><1><1490248>
        END_DIRECTORY
        BEGIN_DIRECTORY
            <inboxes\smsbkup.box>
            <9><X86><>
            FILE <smsbkup.ctl><0><12919>
        END_DIRECTORY

     

    and 

    <SMS_SITE_SQL_BACKUP>
        <1193>
        BEGIN_DIRECTORY
            <bin\i386>
            <9><X86><>
            FILE <smssqlbkup.exe><1><759808>
            FILE <srvboot.exe><0><333664>
        END_DIRECTORY
        BEGIN_DIRECTORY
            <bin\x64>
            <17><AMD64><>
            FILE <smssqlbkup.exe><1><1469768>
        END_DIRECTORY
        UNIT <SMS>

    3. Restarted server. Same error I am getting.

    Please suggest


    SiddheshM MCTS
    Friday, September 09, 2011 9:55 AM

Answers

  • Have you already checked if built-in\system and the computer account of the siteserver got sysadmin priviliges on the SQL server?


    Torsten Meringer | http://www.mssccmfaq.de
    • Marked as answer by SiddheshM Friday, September 09, 2011 11:16 AM
    Friday, September 09, 2011 11:02 AM
    Moderator

All replies

  • Have you already checked if built-in\system and the computer account of the siteserver got sysadmin priviliges on the SQL server?


    Torsten Meringer | http://www.mssccmfaq.de
    • Marked as answer by SiddheshM Friday, September 09, 2011 11:16 AM
    Friday, September 09, 2011 11:02 AM
    Moderator
  • Previously I was just checking Events on Primary server..where as there are clear errors in eventvwr of database server.

    Seems to be it is working now.

    Torsten is exactly on the spot.


    SiddheshM MCTS
    Friday, September 09, 2011 11:25 AM