Recovering Disk space

We copied a large amount of data from one server to another. The data files for tempdb grew  to a point where it used up almost all available disk space.  I stopped and started the services and even went as far as rebooting the server. SQL will not release the free space back to the OS.  BOL says that tempdb is re created everytime SQL Server is started.  Any suggestions????
LVL 1
jvoconnellAsked:
Who is Participating?
 
wael_tahonCommented:
I had this problem in the past
you can find how to solve it in:

http://support.microsoft.com/default.aspx?kbid=307487

0
 
sigmaconCommented:
In enterprise manager, have you tried to shrink tempdb yet? That usually makes actual changes to the data file size.
0
 
jvoconnellAuthor Commented:
I did try that and it decreased the used space but the free space is still being retained by SQL.
0
 
Partha MandayamTechnical DirectorCommented:
Since you copied a large amount of data, the transaction log must have got full. Try shrinking the log as per the following article
http://support.microsoft.com/default.aspx?scid=kb;EN-US;272318
0
 
jvoconnellAuthor Commented:
Thanks a million!!!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.