Shrinkfile does not find the file

From: Question on SQL (qs_at_who.com)
Date: 09/10/04 

Date: Fri, 10 Sep 2004 14:14:11 -0500

Hi group,

when I try to

DBCC SHRINKFILE ('GCSFSSYSlog', 200,TRUNCATEONLY )

I get

Server: Msg 8985, Level 16, State 1, Line 1
Could not locate file 'GCSFSSYSlog' in sysfiles.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.

However,

select * from sysfiles where name = 'GCSFSSYSlog'

does get a result.

What's wrong?

Relevant Pages

  • missing indexes
    ... I'm trying to run a query against a linked sql server. ... If DBCC printed error messages, ... system administrator. ...
    (microsoft.public.sqlserver.programming)
  • error message
    ... Could not locate file 'wslogdb62_log' in sysfiles. ... If DBCC printed error messages, ... contact your system administrator. ...
    (microsoft.public.sqlserver.connect)
  • Re: Integ. Chk - Missing Object
    ... > sysobjects. ... If DBCC printed error messages, ... > contact your system administrator. ...
    (microsoft.public.sqlserver.server)
  • Integ. Chk - Missing Object
    ... I almost for sure can't be missing a significant table or ... If DBCC printed error messages, ... contact your system administrator. ...
    (microsoft.public.sqlserver.server)
  • Re: LDF deleted, please help
    ... If DBCC printed error messages, ... system administrator. ... >> Can you tell me how can I attach it, without the ldf file? ...
    (microsoft.public.sqlserver.server)