Help Needed

From: pankaj_wolfhunter@xxxxxxxxxxx
Date: 29 May 2006 22:37:03 -0700

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

.

Follow-Ups:
- Re: Help Needed
  - From: Brian Peasland
- Re: Help Needed
  - From: Jim Kennedy

Prev by Date: Re: Performance Problem with Full Text Indexing
Next by Date: Re: Interview Index problem
Previous by thread: Performance Problem with Full Text Indexing
Next by thread: Re: Help Needed
Index(es):
- Date
- Thread

Relevant Pages

Re: LOG Device Corrupted
... Check the documentation for the correct DBCC ... It seems your old database have mutiple LDF files. ... Stop sql server and rename the existing MDF to a new one and copy the ... Now execute the undocumented DBCC to create a log file ...
(microsoft.public.sqlserver.server)
Re: torn page
... It is not required to make the SQL Server to start in single user mode. ... the DBCC with Rebuild option to sinlge user. ... How to make database to single user:- ...
(microsoft.public.sqlserver.server)
Re: How do I shrink my logfile?
... > I followed the instructions in the link but when I run DBCC ... >> See DBCC SHRINKFILE in SQL Server Books Online. ... >> Is .NET important for a database professional? ...
(microsoft.public.sqlserver.server)
Re: Help Needed
... I have sql server 2000 sp3 on windows 2000 server. ... of the database we have with 40 GB data. ... DBCC execution completed. ... If DBCC printed error messages, ...
(comp.databases.oracle.server)
RE: internal consistency error
... Could you please confirm that the SQL Server is up and running and the database in question is online. ... On running DBCC CHECKDB does it shows some inconsistency and allocation error on the second last line of output... ...
(microsoft.public.sqlserver.server)