THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Tools » Installation   (RSS)
  • Managing the errorlog file

    I frequently see recommendations to regularly run sp_cycle_errorlog, so that the errorlog doesn't become huge. My main concern with that is that the errorlog contains valuable information. When I do a health check on a SQL Server machine, I want a few months worth of errorlog information available. I typically use my own scripts for this, ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on October 22, 2015
  • Analyzing the errorlog

    How often do you do this? Look over each message (type) in the errorlog file and determine whether this is something you want to act on. Sure, some (but not all) of you have some monitoring solution in place, but are you 100% confident that it really will notify for all messages that you might find interesting? That there isn't even one little ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on July 5, 2012
  • Rebuild master in SQL Server 2008

    You might have read an earlier blog entry about my problems to remove a Data Collector (DC) information in SQL Server 2008. I still haven't found any info on how to do this, but my questions in the MVP group triggered some activity. Bob Ward looked into how to rebuild the system databases. This was on my list to try (after removing DC config and ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on August 29, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement