SQL Server Performance Forum – Threads Archive

Unable to shrink tempdb file

when ever i tried to shrink my tempdb data(live production server) file which is 8.5 gb size ,i’m getting following error: File ID 1 of database ID 2 cannot be shrunk as it is either being shrunk by another process or is empty.
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded. please help me on this issue..

---

Try to shrink it after bouncing SQL server. here are methods suggested by microsoft. http://support.microsoft.com/default.aspx?scid=KB;EN-US;307487 Dont go on my posts iam still a student (*_*)

---

Hi, Check whether autoshrink option is enabled for tempdb, if yes check autoshrink is going on at the time you try to shrink. Since the error you displayed is seems to be like that. Disable autoshrink option and then try to shrink tempdb. I think this will work. Sagar

---

Why you are attempting to shrink the tempdb, do you have any disk space issues?
You have to be careful to shrink it as other processes & queries will be using tEMPDB a lot, in which case you will have this problem again. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

]]>