Tilted Forum Project Discussion Community - View Single Post - [SQL Server 2000] Auto shrinking transaction logs?

Stompy · 05-25-2004, 08:25 AM

For some odd reason, SQL Server 2000 doesn't have a "Truncate Log on Checkpoint" option that 7 had... so now all the transaction logs on our new servers are just getting way outta control.

There's a command you can use to shrink it:

Code:

use db
BACKUP LOG db WITH TRUNCATE_ONLY
DBCC SHRINKFILE ('db_Log', 2)

But that's tedious to run it on every individual database.. there's gotta be a way to have SQL do this for you. I can't seem to figure out what it is.

Anyone have any ideas?

05-25-2004, 08:25 AM	#1 (permalink)
Stompy Banned from being Banned Location: Donkey	[SQL Server 2000] Auto shrinking transaction logs? For some odd reason, SQL Server 2000 doesn't have a "Truncate Log on Checkpoint" option that 7 had... so now all the transaction logs on our new servers are just getting way outta control. There's a command you can use to shrink it: Code: use db BACKUP LOG db WITH TRUNCATE_ONLY DBCC SHRINKFILE ('db_Log', 2) But that's tedious to run it on every individual database.. there's gotta be a way to have SQL do this for you. I can't seem to figure out what it is. Anyone have any ideas? __________________ I love lamp.