December 28, 2007 at 8:00 am
I created a database called wslogdb85 in which each partition has been set to rollover every 10GB.
The partitions are growing fine, ie. wslogdb85_1, but the main database .mdf &.ldf do not grow at all. My tempdb.mdf and templog.ldf are growing significantly though.
I have 160GB free of disk space. I noticed this happening last week.
The reporting aspect is fine. I can run reports off the data.
Server Specs:
2003 Server R2 SP2
2000 SQL Server SP4
Any help on why this is happening would be greatly appreciated.
December 28, 2007 at 9:26 am
You must have some open transaction in tempdb that is holding space. It should be in simple mode and truncate itself (log) every few minutes. If tempdb is growing constantly, something is preventing truncation.
If it's grown (data) and seems stable, it's because of load. You might not have sizes tempdb appropriately for your system
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply