Help Needed

From: <pankaj_wolfhunter_at_yahoo.co.in>
Date: 29 May 2006 22:37:03 -0700
Message-ID: <1148967423.919291.215190@38g2000cwa.googlegroups.com>

Greetings,

I have sql server 2000 sp3 on windows 2000 server. On one of the database we have with 40 GB data. It have more than 100 GB of free space in the filegroup. I tried to shrink that file using DBCC SHRINKFILE('FILENAME') and it gave me following error

Server: Msg 3140, Level 16, State 3, Line 1 Could not adjust the space allocation for file 'dbfile_Dat'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

here the space is adequate

Can anyone help me with this?
Any help would be appreciated

TIA Received on Tue May 30 2006 - 00:37:03 CDT