Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 transaction log filling up

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-05-17 : 17:28:26
Chuck writes "I have a transaction log file on one of my MS SQL Server 7 databases and it is filling up even though I have its properties set to afford its dynamic sizing. I grew up with Sybase SQL Server before migrating to Microsoft SQL Server. Sybase SQL Server had a stored proc called sp_thresholdaction that would call a dump tran and live would go on merrily. How does a Microsoft SQL Server DBA programmatically deal with a transaction log filling up?

Thanks,

Chuck"
   

- Advertisement -