Post reply

What to Check in SQL logs

  • January 17, 2010 at 12:01 pm

    #214617

    Hi Friends,

    I am a trainee DBA,

    My senior DBA told me to check sql logs

    But

    can anyone tell me

    what to check in logs(eg kind of erros and how to resolve them)?

  • January 17, 2010 at 1:34 pm

    #1104730

    We need check backup failures ,out of space issue ,checkdb corruption,

    log file full, everything whcih contain errors. and you can check backup abnd resotore completion time . killed process. u can also get IP address ,port number of server is listing etc....

  • January 17, 2010 at 1:43 pm

    #1104731

    Really you need to check any errors. Lots of information things can get put into the log, but any error needs to be investigated.

    The resolution will vary widely depending on the error.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply