Hello,

I try to shrink DB, in "Shrink action" I mark "Truncate free space from the
end of file". After press "OK" button I see such a message:

"Error 8985: Could not locate file "file_name.dat" in system.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator."

So, can you tell my what is wrong ? How to resolve this problem ?

Fibre Optic

"Fibre Optic" <fibre_optic@go2.pl> wrote in message
news:cfam4n$nm0$1@inews.gazeta.pl...
> Hello,
>
> I try to shrink DB, in "Shrink action" I mark "Truncate free space from
the
> end of file". After press "OK" button I see such a message:
>
> "Error 8985: Could not locate file "file_name.dat" in system.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator."
>
> So, can you tell my what is wrong ? How to resolve this problem ?
>
> Fibre Optic
>
>

The error suggests that you have the wrong file name - are you doing this
from Enterprise Manager, or from another tool? You should probably try
shrinking the file directly from Query Analyzer:

http://support.microsoft.com/default...&Product=sql2k

Simon