Have a backup handy?

Have you had any luck with this command?

USE [master]

GO

ALTER DATABASE [msdb] MODIFY FILE ( NAME = N'MSDBLog', MAXSIZE = 1024000KB , FILEGROWTH = 25600KB )

GO

Try running this in a query window:

USE [master]

GO

ALTER DATABASE [msdb] MODIFY FILE ( NAME = N'MSDBLog', MAXSIZE = 1024000KB , FILEGROWTH = 25600KB )

GO

Also, I would be interested to see...

Oh wow! I did not notice the dates. I just got the notifications yesterday so I thought it was a live thread.

Before you go the multiple tempdb files route please read this post by Paul Randal: http://www.sqlskills.com/BLOGS/PAUL/post/Search-Engine-QA-12-Should-you-create-multiple-files-for-a-user-DB-on-a-multi-core-box.aspx. He actually wrote the code that does this so you are not...

Most of the time you are running into cached temp tables. Query plans with temp tables keep the first page in tempdb when you are done using them so you...

The whole shadow copying thing scares me because if you have log and data on seperate drives you could introduce corruption like you would see with SAN snapshots. I prefer...

Any chance they are using DPM?

Are they excluding mdfs too or just ndfs and ldfs?

What does select * from sys.databases return?

Just to clarify, the response from Microsoft was to not maintain XML indexes?

SQL 2005 caches a lot of things in tempdb, most tied to a query plan. Try a DBCC FREEPROCCACHE then you should be able to shrink. I should mention though...

I would suggest getting to at least SP3 for SQL 2005 and making sure the OS is fully patched too. It would probably be best to get the OS fully...

You may have larger problems than tables lingering about TempDB if there are tables out there from 2008. Since TempDB is completely recreated every time SQL restarts I am betting...

I had the same problem. Just reboot and rerun the sp3 install before opening any programs.

I have always seen the recompile hint as a great way to get out of the business day especially on an OLTP system but I have never used it at...