Tag Archives: DBCC

Possible SQL Server Trace Flag Gotcha

I was trying to turn on Traceflag 3226 in order to suppress the swarm of successful transaction log backup messages that floods the SQL Server (Error) Logs (& Windows Application logs). After all, if you’ve got more than a few … Continue reading

Posted in SQLServerPedia Syndication | Tagged , | 1 Comment

Querying SQL Server Event Logs to search for DBCC CheckDB output

This is a long-winded response to a query raised on AskSSC, about how to report on the running of DBCC. One way suggested was to use Ola Hallengren’s scripts to schedule and report. However, I have another way that I … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , | 5 Comments

Adventures with DBCC and Database Upgrades

We have (had?) an application that has been retired (Hurrah!). ¬†However, even though it has been retired, there is still the occasional request to extract data from this database, which was hosted on a SQL2000 SP3a server. ¬†So what I’m … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , , | 3 Comments