Re: Shrinkfile does not find the file
From: Stephen Yuan Jiang [MSFT] (syjiang_at_online.microsoft.com)
Date: 09/13/04
- Next message: John Schuster: "Transaction log"
- Previous message: Stephen Yuan Jiang [MSFT]: "Re: emptying data file and removing it"
- In reply to: Question on SQL: "Shrinkfile does not find the file"
- Next in thread: Question on SQL: "Re: Shrinkfile does not find the file"
- Reply: Question on SQL: "Re: Shrinkfile does not find the file"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 13 Sep 2004 14:25:54 -0700
This indeed looks strange to me. One more thing to try: If you pass in
fileId (you can get it from sysfiles) instead of file name in the first
parameter of DBCC SHRINKFILE, will shrink recognize the file?
--
Stephen Jiang
Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Question on SQL" <qs@who.com> wrote in message
news:#a9G3p2lEHA.3428@TK2MSFTNGP14.phx.gbl...
> 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?
>
>
>
- Next message: John Schuster: "Transaction log"
- Previous message: Stephen Yuan Jiang [MSFT]: "Re: emptying data file and removing it"
- In reply to: Question on SQL: "Shrinkfile does not find the file"
- Next in thread: Question on SQL: "Re: Shrinkfile does not find the file"
- Reply: Question on SQL: "Re: Shrinkfile does not find the file"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
Loading
