Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Unanswered: garbage in sql server log files

    hi,
    My database server had hung up recently, and I had to restart it.
    After checking the log I found some garbage entries in it.
    has anyone encountered similar errors?
    harshal.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Garbage entry means what some of kind of ASCII characters or SQL DMP information?

    Post a sample one here.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    Originally posted by Satya
    Garbage entry means what some of kind of ASCII characters or SQL DMP information?

    Post a sample one here.
    There is some kind of ascii code

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    What is the level of service pack on SQL & OS?
    What was the error related when it hung?
    Any SQL.DMP files are created?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    Originally posted by Satya
    What is the level of service pack on SQL & OS?
    What was the error related when it hung?
    Any SQL.DMP files are created?
    Error: 17883, Severity: 1, State: 0
    The Scheduler 0 appears to be hung. SPID 94, ECID 0, UMS Context 0x39836B08.

    sp3a and win 2k .

  6. #6
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Review information on following KBAs to deal with:
    http://support.microsoft.com/?kbid=816840

    http://support.microsoft.com/default...b;en-us;810885 - I feel this may be applicable to the situation if you use high-end subsystems h/w.

    HTH
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •