Re: Help Needed

pankaj_wolfhunter_at_yahoo.co.in wrote:
> 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
>

Did you try DBCC SHRINKDATABASE instead?

Otherwise, please post to comp.databases.ms-sqlserver instead. This is an Oracle forum.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown