Transaction Log Data out of control

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 Data out of control

Author

Topic

tad
Starting Member

31 Posts

Posted - 2002-07-15 : 16:02:28

My DB is 1 GB , TL is 47 GB.

I'm in development, so I'm not backing up the TL. I tried shrinking it, but it didn't shrink. I tried deleting it, but I couldn't.

Suggestions ?

Thanks

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-07-15 : 16:04:50

First, do:

BACKUP LOG myDB WITH NO_LOG

Then try using DBCC SHRINKFILE on it.

1fred
Posting Yak Master

158 Posts

Posted - 2002-07-15 : 16:15:32

exec sp_dboption N'DBName', N'trunc. log', N'true'

exec sp_dboption N'DBName', N'autoshrink', N'true'

Try this, and your log should not grow more than 1mb, and the size should decrease after making some transactions. I know others don't recommand this, but if it is not a transactionnal site, I think you can do this.

tad
Starting Member

31 Posts

Posted - 2002-07-15 : 16:50:12

That worked great. Thanks

quote:

First, do:

BACKUP LOG myDB WITH NO_LOG

Then try using DBCC SHRINKFILE on it.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources