Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help Needed
<pankaj_wolfhunter_at_yahoo.co.in> wrote in message
news:1148967423.919291.215190_at_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
>
I'm sorry this is an Oracle group. Oracle!-SQL Server.
Jim
Received on Tue May 30 2006 - 00:44:56 CDT