When should you rebuild the transaction log?

How banks can steal your money

SimonS SQL Server Stuff — Thu, 15 Jun 2006 22:08:55 GMT

If you ever visit the forums you will learn many ways to manage your SQL Server. Some of these are good...

Ta da! Emergency mode repair

SQL Server Storage Engine — Sun, 18 Jun 2006 18:15:04 GMT

Emergency mode repair? In a couple of previous posts I explained how the two worst things you could do...

re: When should you rebuild the transaction log?

phront — Sat, 30 Dec 2006 11:44:19 GMT

what to do when mdf & log are bad and if dbcc REPAIR_ALLOW_DATA_LOSS cause assertion at logmgr.cpp with expression (minLSN.m_fSeqNo < lfcb->lfcb_fSeqNo)?

How banks can steal your money

SimonS SQL Server Stuff — Sun, 12 Aug 2007 02:51:33 GMT

If you ever visit the forums you will learn many ways to manage your SQL Server. Some of these are good

re: When should you rebuild the transaction log?

vibemill — Tue, 27 Nov 2007 14:09:07 GMT

Hey Paul, you say "don't be daft, never!"

I have a sql 2005 express database that is 1.4 gb ,,, the transaction file grew to 84 gb ... sql is pathetic!!!

Oii, enough already!!! there is no way that the transaction file should with default swettings grow to that ridiculous size. the database is backed up every day. It is not mission critical to the extent of a live transaction bank account database or airline reservation database. Even if it was, the size of the transaction file should NOT grow to 60 times the size of it's database. You have nothing to be proud of or smart about ... FIX IT!!!

shalom, Robert

re: When should you rebuild the transaction log?

cisjokey — Thu, 09 Oct 2008 16:05:03 GMT

Hello Dear

First, thanks for this article!

To bad to see poeple with no background knowledge, trying to blame you.

"Don't be daft, never!" is just a great and clean statement.