SQL Server Logs too

  • My backup fails in maintenance plan and the worse part of it I can't open my sql error logs to see what is the problem, they are too big something like 2 gbs.how can I partition these logs to make them small and easy to open

    Thanks

  • You could try using a text editor (a good one). Notepad++, ultraedit, etc

    You can cycle the error log and SQL will start a new one, then you can read the new log.

    exec sp_cycle_errorlog

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • You should set your maintenance plans to log, they can do this in text files and don't necessarily need to send to the SQL Server error logs.

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

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