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_tahonConnect With a Mentor Commented:
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
 
mcp111Commented:
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
All Courses

From novice to tech pro — start learning today.