If you have nothing in place currently, then backup size history is what you can go on to estimate space used... but this might not give you free disk space...

I don't think so- my understanding is that the methods described in http://support.microsoft.com/kb/307487 are the only ways to shrink tempdb.

The question is what causes the tempdb...

hahaha! didn't even notice... was researching a similar topic and knew the answer so figured what the heck...

Most likely this is MS Search running as part of Full Text Search... I often see this on db servers hosting sharepoint databases.

Just FYI, incase anyone has a similar problem:

This problem was created because triggers were in place to audit changes to any of the tables, and those triggers write to an...

Just FYI, incase anyone has a similar problem:

This problem was created because triggers were in place to audit changes to any of the tables, and those triggers write to an...

Just FYI in case anyone else comes across a similar problem. In this scenario, drastic performance improvement was obtained by defragmenting the index on msmerge_contents. Due to log...

Forgot to mention... the following comes with no warranties or guarantee that it wont totally mess things up... but it works great for me.

I am using various scripts and jobs...

Hi Kevin,

Microsoft lists the supported upgrade paths here: http://msdn.microsoft.com/en-us/library/ms143393(SQL.90).aspx

You don't want to just drop in the disc and hope for the best. MS gives a good summary...

I've seen this when the SQL Agent account doesnt have rights to the database server. If you have removed Builtin\administrators and the agent runs as local system, add the...

Thanks all for the valueable insights. I tend to agree with Ed regarding backup partitions- why waste the resources when were deleteing and recreating daily.

David- I dont think I...

Tape backup does it too, but I've scheduled around it. I definitely identified Diskeeper as the offender- using procexp to identifiy it, then watched it disappear as soon as...

Diskeeper is what we have been using, but it seems to "lock files" from time to time. The result is that my backup job is unable to delete an...

Just to be clear- you should execute proc exp, do Find > Find Handle and enter "modellog.ldf" to ensure that some process is not locking the file.

certainly a possibility.