SQL2000 Transaction Log not shrinking
Posted on 2010-09-09
I have a SQL2000 DB (450GB) that currently has a transaction log (multiple files) of 110GB. The DB was in simple mode and the last complete backup was completed 2 days ago. The normal full backup runs one a week. The logs have just recently started growing without shrinking after backup. I have put the db in full and bulk mode and done a transaction log backup and stil no shrink??? I have looked on this sit, trying to research other possible methods for getting the log file size down, but nothing has worked thus far. Here are some otf the actions taken:
(1) run DBCC SHRINKFILE ('filename',1)
(2) run DBCC SHRINKFILE ('filename',truncateonly)
(3) BACKUP LOG xxx_DatabaseName_xxx WITH TRUNCATE_ONLY
I would appreciate any assistance, I have very limited space on this server.