In my ongoing effort to automate everything.  I wanted to have a script that would change the default number of error logs.   Aftersome looking around in help and on the internets, I realized I was going to have come up with a solution on my own.   I was complaining to Ryan about having to do some real work,  when he suggested that I just run a trace when  I make the change via Management Studio.

Warning:  This post involves the death a dog, if you are sensitve.   

Brent Ozar is hosting a webcast today about disaster recovery horror stories and I thought back to my “favorite” horror story and how much I have learned since then.  I have been working with SQL Server since 1997, but I was not a real dba until I took a job at large insurance company in 2000.  At that time, a lot of large companies only trusted SQL Server to be the back end to their websites, but did not trust it to run their actual business.