Re: Shrinkfile does not find the file
From: Question on SQL (qs_at_who.com)
Date: 09/13/04
- Next message: Chris: "Re: Is SQL 7.0 obsolete yet?"
- Previous message: yooyoo: "Re: connection error after 15 minutes of restart"
- In reply to: Hari Prasad: "Re: Shrinkfile does not find the file"
- Next in thread: Stephen Yuan Jiang [MSFT]: "Re: Shrinkfile does not find the file"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 13 Sep 2004 09:41:35 -0500
Thanks. It returned exactly the same file names as select * from sysfiles.
"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:%23kIecYCmEHA.2412@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> Looks like the logical name have some issues.. could you execute the below
> command to get the logical name for that database.
>
> sp_helpdb 'databasename'
>
> After that use this logical name in DBCC SHRINKFILE command and try.
>
> Thanks
> Hari
> MCDBA
>
>
> "Question on SQL" <qs@who.com> wrote in message
> news:%23a9G3p2lEHA.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: Chris: "Re: Is SQL 7.0 obsolete yet?"
- Previous message: yooyoo: "Re: connection error after 15 minutes of restart"
- In reply to: Hari Prasad: "Re: Shrinkfile does not find the file"
- Next in thread: Stephen Yuan Jiang [MSFT]: "Re: Shrinkfile does not find the file"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
