Transaction log isn't getting smaller in SQL 2000

[bessebo]

Today is our first day in production with SQLServer 2000. I am monitoring the transaction log and I have noticed that it is never shrinking and is just growing (not drastically though). I have transaction log backups running every 15 minutes but even right after the transaction log backup the log does not get smaller. Does anyone have any ideas?

 

[mrdenny]

The log will not shirk automatically. The data will be removed from the log, but the log size will stay the same (unless is needs to grow). This is normal.

There is no point in shrinking the log as it will just grow again until the next log backup.

In EM view the database info in taskpad view. This will show you how much info is in the transaction log file.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[bessebo]

Do you perform log backups on a regular basis? And, if so, does the used portion of the transaction log go down after each transaction log backup? I decided to take the Auto Shrink option off because I don't want any added load on the server.