none
Multiple Jobs failing - SQL 2005 - Communication Link Failure

    Question

  • Specifications
    ~~~~~~~~~~~~~~
    OS Information:
    ~~~~~~~~~~~~~~~
    Windows NT 5.2 64Bit Enterprise Edition (AMD64)
    CPU: 4 Nos
    Memory: 16GB
    C Drive: 120GB (51GB Free)

    SQL Server:
    ~~~~~~~~~~
    Microsoft SQL Server 2005 - 9.00.4207.00

     

    Backup jobs on my server are failing since 3 days.  When I read SQL Agent Log, It says:

    2009-12-22 11:30:00 - ! [298] SQLServer Error: 233, Named Pipes Provider: No process is on the other end of the pipe. [SQLSTATE 08S01]
    2009-12-22 11:30:00 - ! [298] SQLServer Error: 233, Communication link failure [SQLSTATE 08S01]
    2009-12-22 11:30:00 - ! [298] SQLServer Error: 16389, Communication link failure [SQLSTATE 08S01]

    When I googled, I could see some memory related issues but I see no memory issues: (See below output for DBCC MEMORY STATUS)

    Memory Manager                  KB
    ------------------------------ --------------------
    VM Reserved                    16974968
    VM Committed                   11633248
    AWE Allocated                  0
    Reserved Memory                1024
    Reserved Memory In Use         0


    Could someone please look into this and help me....Thanks In Advance

    Vicky


    Thanks
    Thursday, December 24, 2009 12:57 PM

Answers

All replies