Thanks GSquared,

Will take aboard your advice with the SQL Trace.

ahutch

Sorry my mistake, just checked our scheduled jobs, we don't log ship tempdb ...

Thanks for all your suggestions, rather than reply separately to all of them, I hope you don't mind if I just group them together ...

aali_online

The log file don't grow as...

Thanks Phil,

I suppose if increasing disk space is the only way to go then we have to look into what capacity we can add to our server.

Based on your experience...

aali_online,

Would truncating the tempdb log file affect the rate the tempdb data file grows? It seem to us that it is the data file growth that is causing the problem....

Hi Prem

Thanks for your suggestion, again we are trying not to have to restart the sql server, and moving the tempdb to another drive just means it will eventually use...

Thanks for your reply Happycat59.

I suppose buying more disk space is one option, but we were looking at what can be done with our current server setup.

No matter how...