Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    50

    Unanswered: DBCC SHRINKFILE fail

    When i excute this command

    DBCC SHRINKFILE(pubs_log, 2)

    the message "Could not locate file 'TEST' in sysfiles.
    DBCC execution completed. If DBCC printed error messages, contact your system administrator." raiseed.
    please what is it?
    thank a lot

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    Howdy

    Make sure you are running this command against the correct database in Query Analyser ( select the database at top of screen ). You cant run this command against Master database.

    Cheers,

    SG.
    Last edited by sqlguy7777; 02-18-04 at 23:32.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •