My Transaction Log Filled Up My Hard Drive!

Here’s another great story from the trenches that I read today on MS SQL Tips: http://www.mssqltips.com/tip.asp?tip=2092. The interesting resolution from this instance seems to result from recompiling an old stored procedure. But what you may find more interesting is the methods that were taken to uncover the offending source and the steps taken to change the backup & recovery model to get the application back online. This is never a fun scenario …

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s