Unable to truncate log? - SQL Server Forums

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)

Unable to truncate log?

Author

Topic

readysetstop
Posting Yak Master

123 Posts

Posted - 2007-03-05 : 10:50:41

I have a 2.5 GB database with a 145 GB log file (The things I inherit around here...) I have changed the recovery model to simple and ran BACKUP LOG STCRRB WITH TRUNCATE_ONLY. The log file still remains at 145 GB.

Figuring I missed something, I ran the following:


alter database stcrrb
  set recovery simple
go
backup database stcrrb to disk = 'D:\STCRRB.bak'
backup log stcrrb with TRUNCATE_ONLY
go

Still at 145 GB on the log. I ran DBCC OPENTRAN(STCRRB), but it said there were no open transactions, so that's not it. What should I check or do next?

Thanks for any and all help.

-D.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-03-05 : 11:16:45

run dbcc shrinkfile

and read this:
http://www.nigelrivett.net/SQLAdmin/TransactionLogFileGrows_1.html

Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

readysetstop
Posting Yak Master

123 Posts

Posted - 2007-03-05 : 12:25:15

spirit1,

The command worked perfectly, and the link was quite helpful. Thanks for both.

-D.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources