Database Shrink

[shultz]

I've got a serious problem on my SQL Server. Yesterday I noticed that the Drive where I store my Databases is full and it's not letting me store any more data. I tried to clear of all the unwanted data but still it's the same problem.

I noticed that the tempdb has been grown to 3GB and if I look into the tables it's not using any space at all. I tried to truncate the transaction log and also tried to shrink the database. I even restarted the server but still it has not freed up any space. Could anybody tell me how to release the unused space.

The space allocated is 3GB where as the used space is 0 bytes. Any help please.

 

[bperry]

There is an faq for this forum on shrinking issues:

faq183-1534

Is there any help there?

 

[bperry]

Assuming it is tempdb that is clogging the disk, you should probaby look at this:

http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q307487

It seems to be instructions on how to shrink the tempdb database. Hopefully that's what you need!

bp

 

[bperry]

Hello again:
Still thinking that the size of tempdb is your problem, so following method 3 in the MS article mentioned above, I used this script below to shrink the data file of my tempdb database from 8 MB to 3 MB.

use tempdb
go
dbcc shrinkfile (tempdev, 3)

Worked fine for me.
(But no warranty implied! Read the article first.)

hope this is on the right track,
bp