Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  TempDB has filled my data disk.

Author  Topic  JDMils Starting Member 3 Posts Posted - 2010-03-09 : 21:15:10 I have a SQL 2005 Enterprise environment which I have inherited recently. The disk is 557 GB and the physical TempDB file is 499 GB! I have run the shrink commands as found on http://support.microsoft.com/default.aspx/kb/307487 without stopping the SQL services. I assume these steps have shrunk the virtual files within the TempDB.mdf only. I want to reduce the size of the MDF file so that it no longer uses 499 Gb of the data disk, but no matter what I do I can not find a solution which does not require a reboot of SQL services. Is this the only solution, to stop SQL services? If so, if I re-run the commands listed on the above MS article, will that shrink the physical file from 499 GB to a more reasonable size? Thanks.