Download these T-SQL scripts to help you use and manage the SQL Server errors logs more efficiently instead of having to navigate using the GUI.
The Error Log Scripts include:
- Quickly find errors and all associated error lines
- Quickly find location of where error log file is written
- How to stop logging successful backup messages to error log
- How to cycle the error log to archive old and create empty log file
- Searching for text in error log files
- Finding errors and warnings in log file and default trace
- and more
Check out these related downloads:
For 20+ years, MSSQLTips.com has been delivering comprehensive technical solutions on a daily basis for the Microsoft SQL Server platform. In that time, an innovative team of over 300 authors from around the globe have delivered over 7000 articles and 1000 webcasts ranging from beginner topics to advanced solutions. Our community prides itself on delivering human only generated content.
