RSingh (1/31/2009)

---

Hi,

We have a 500 GB database.

We deleted 75% of old data and then rebuilt most of the indexes.

As a result of all this we had enough free space in the datafiles.

To reclaim most of the space I was trying to shrink the datafiles (15 in all).

Although most of them shrunk successfully, one of them has failed with this error:

Could not adjust the space allocation for file 'PCRDATA14'

This file is 26.6 GB in size. 7.8 GB is the used space and it had 18.8 GB free space. I was shrinking it with this command:

DBCC SHRINKFILE(PCRDATA14,15000)

GO

Any idea why the file is not shrinking? and how can I shrink it?

Regards