Re: Shrinkfile does not find the file

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 09/11/04 

Date: Sat, 11 Sep 2004 12:38:58 -0500

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?
>
>
>

Relevant Pages

  • Re: DB Space
    ... > "Hari Prasad" wrote: ... >> Can you execute the below command to ghet the actual database size. ...
    (microsoft.public.sqlserver.msde)
  • Re: C# command doesnt time out appropriately...why?
    ... record in our database that matches the search criteria, ... only by increasing the timeout in our VB application, little by little, ... I'm basically trying to execute the command, which of course is a call ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: DBCC error 913
    ... Then I run the command sp_dboption dbname,'Single user',true also. ... this command runs inside a cursor and DBCC checkdb commands starts after that. ... >> This is simple DBCC script I am running on the server every sunday. ... >> database is online and in live. ...
    (microsoft.public.sqlserver.server)
  • Re: How to deny DBCC SQLPERF(logspace)
    ... DBCC statements that act as Database Console Commands for Microsoft? ... I know that if we can find the place where the permissions of each DBCC ... command stored, we can update the table directly to change the permissions. ...
    (microsoft.public.sqlserver.security)
  • Re: Set Restricted_User
    ... to the database, the connection may drop as the database ... the other users but for the app that executes the command to ... Then execute the command and then try ...
    (microsoft.public.sqlserver.security)