Wednesday, March 21, 2012

DB shrink problem

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/defaul...8&Product=sql2k

Simon

No comments:

Post a Comment