Can't Shrink a SQL 2005 Database

[pbibler]

When I try to shrink one of my db's, I get the following error: "File ID 1 of database ID 6 cannot be shrunk as it is either being shrunk by another process or is empty."

The database is 140GB, of which it shows 40GB free, I just can't get it to shrink. I have done DBCC shrinkfile, and DBCC Shrinkdatabase, as well as DBCC Updateusage. I can't back it up because I don't have the space anywhere to back it up (don't ask, I know how that sounds. The server is being backed up in its entirety, at least.)

Any ideas? Much appreciated.

Thanks,

Paul

 

[mrdenny]

How many files does the database have? Is the autoshrink check box checked in the database properies?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog