Post reply

SQL 2005 - Looking for a DB deleted - The system cannot find the file specified

  • November 9, 2009 at 6:32 pm

    #156390

    Hi Guys,

    I'm getting the following error messages when SQL is starting

    FCB::Open failed: Could not open file S:\Databases\******_Data.MDF for file number 1. OS error: 2(The system cannot find the file specified.).

    FCB::Open: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'S:\Databases\*****.LDF Diagnose and correct the operating system error, and retry the operation.

    Today I restore this DB and the restore failed, so I drop the DB, it look like the system is still looking for the log and the data of the DB that I drop.

    Any ideal how I can fix that ?

    thanks you very mutch !

  • November 10, 2009 at 7:39 am

    #1077254

    There's still a database referencing those files. Query sys.master_files, see which db is referring to those files, then drop that database.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 10, 2009 at 3:23 pm

    #1077564

    If you query sysdatabases is there still an entry for the database?

    Joie Andrew
    "Since 1982"

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply