SQL Server Jobs error: Unable to read event log RRS feed

  • Question

  • Hello world,

        I am trying to run a job that backs up my master database.  The job errors out with 'Unable to read event log.'  There are no alerts or notifications set and all SQL Services are currently running.  What am I missing




    Thursday, March 25, 2010 3:24 PM


  • For anyone concerned.  The T-SQL statement I was using in the backup database command had a date with a convert to a string.

    set @mydate=convert(varchar, getdate(),101 ).   This 101 format produces a date such as 3/10/2010.  SQL Server does not like the backslash characters.  It produces an error. 




    MCA 146

    • Marked as answer by mca146 Friday, March 26, 2010 9:27 AM
    Friday, March 26, 2010 9:27 AM