Tempdb transaction log issue

[bessebo]

For some reason the transaction log of my tempdb grows and does not shrink readily. As a result I have had to issue a Checkpoint on the tempdb database to occur every minute to ensure that the transaction log frees up space. I have Truncate Log on Checkpoint chosen for the tempdb database and we are using SQL 7. Anyone out there have the same issue?

 

[mrdenny]

Has someone changed the recovery method for your tempdb. It should be set to simple. If someone has been playing with the settings for tempdb, restarting the SQL Server will drop and recreate tempdb and reset all the settings back to where they should be.

Denny

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

 

[bessebo]

We are not using SQL2000 so there is no such recovery mode with SQL7. I do have the database set to Truncate Log on Checkpoint though but I still have to issu a checkpoint for it to shrink.

 

[mrdenny]

The recovery modes are named differently in SQL 7. What are the options listed there (I don't have a SQL 7 box handy to look for myself). They may be named something else.

Denny

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