Re: SQL2000: Could not locate file name ... in sysfiles

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 10/14/04 

Date: Wed, 13 Oct 2004 23:06:21 -0500

Try enclosing the file name in single quotes:

    DBCC SHRINKFILE ('test_db_w2_L&P', 5) 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Paul" <Paul@discussions.microsoft.com> wrote in message 
news:B6A5670D-8CF9-459E-B83D-B7DBB507B5FE@microsoft.com...
>I got this error when I ran the dbcc shrinkfile (test_db_w2_L&P, 5).  Does
> anyone know how to make SQL Server recognise the database file name with 
> '&'
> character?
>
> Server: Msg 8985, Level 16, State 1, Line 1
> Could not locate file 'test_DB_w2_L&P' in sysfiles.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>
> Any suggestions would be much appreciated.
>
> Rgds, Paul

Relevant Pages

  • Re: Instance Support
    ... can I install> 16 instances on one system? ... >> 16 is the support limit with SQL Server 2000 ... >> Mike Epprecht, Microsoft SQL Server MVP ... >>> Paul ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server does not exist or access denied
    ... Andrew J. Kelly ... SQL Server MVP ... "Paul" wrote in message ... SQL Server does not exist or access denied. ...
    (microsoft.public.sqlserver.security)
  • Re: Replication Setup Issues
    ... Paul, thank you for the assistance. ... I have added your site to my online SQL Server library. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Redundancy
    ... check out Fail-over Clustering in the SQL Server Books Online. ... SQL Server MVP ... "Paul" wrote in message ... > is not seen on the network a backup server will pick up from the last back ...
    (microsoft.public.sqlserver.server)
  • Re: Database Consistency Error
    ... Did you run it with the repair option that Paul suggested? ... Microsoft SQL Server Storage Engine ... >>> It doesn't look like a hardware problem. ... >>>>> When I run DBCC CHECKDB, ...
    (microsoft.public.sqlserver.server)