Operating system error 2(The system cannot find the file specified.)

  • halifaxdal

    SSCoach

    Points: 19584

    I know this is driving people crazy, there is a 2000 server with only sp2! and it crashed! I am called to investigate, can anyone tell me where to start? I don’t even see the DB in the EM

  • Ninja’s_RGR’us

    SSC Guru

    Points: 294069

    Any drive letter detached on the san?

    NTFS permission changed?

    Anything usefull in the sql error logs?

  • halifaxdal

    SSCoach

    Points: 19584

    Operating system error 2(The system cannot find the file specified.) on device ‘D:\Sql\SELS_log.LDF’ during ForwardLogBlockReadAheadAsync.

  • halifaxdal

    SSCoach

    Points: 19584

    Further track down in eventviewer shows the cause might traced back to much earlier:

    Event Type: Error

    Event Source: MSSQLSERVER

    Event Category: (6)

    Event ID: 17055

    Date: 1/1/2011

    Time: 1:00:01 AM

    User: NT AUTHORITY\SYSTEM

    Computer: ISCSLSDB

    Description:

    3041 :

    BACKUP failed to complete the command BACKUP DATABASE [SELS] TO [SELS Disk Backup] WITH INIT , NOUNLOAD , NAME = N’SELS backup’, NOSKIP , STATS = 10, NOFORMAT

  • halifaxdal

    SSCoach

    Points: 19584

    Never thought happiness can come so early!!!!!!!

    I made a copy to another SQL 2000 server, the DB is up and running there!!!:w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t:

  • Ninja’s_RGR’us

    SSC Guru

    Points: 294069

    Has to be permissions!

  • Jack 95169

    SSC-Addicted

    Points: 401

    Probably permissions
    But in my case, it wasn’t
    Error message said:
    FCB::Open failed: Could not open file E:\UserDatabases\msdb.mdf for file number 1.  OS error: 2(failed to retrieve text for this error. Reason: 15100).
    BUT
    Someone had renamed the file as MSDBData.mdf
    Just check, might save you from tearing your hair out when you can’t find the permissions problem!

Viewing 7 posts - 1 through 7 (of 7 total)

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