ould not open file I:\DataFiles\Alerts.mdf for file number 1. OS error: 3

  • Date,Source,Severity,Message

    02/07/2020 08:57:48,spid20s,Unknown,File activation failure. The physical file name "L:\LogFiles\Alerts_log.ldf" may be incorrect.

    02/07/2020 08:57:48,spid20s,Unknown,FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'L:\LogFiles\Alerts_log.ldf'. Diagnose and correct the operating system error<c/> and retry the operation.

    02/07/2020 08:57:48,spid20s,Unknown,Unable to open the physical file "I:\DataFiles\Alerts.mdf". Operating system error 3: "3(The system cannot find the path specified.)".

    02/07/2020 08:57:48,spid20s,Unknown,FCB::Open failed: Could not open file I:\DataFiles\Alerts.mdf for file number 1. OS error: 3(The system cannot find the path specified.).

    02/07/2020 08:57:48,spid20s,Unknown,Starting up database 'Alerts'.

    02/07/2020 07:52:06,spid52,Unknown,Starting up database 'Alerts'.

    01/29/2020 00:51:29,spid4s,Unknown,processing sp: sp_get_job_alerts

    01/29/2020 00:51:22,spid4s,Unknown,Creating procedure sp_get_job_alerts...

    01/29/2020 00:51:21,spid4s,Unknown,Creating view sysalerts_performance_counters_view...

    01/29/2020 00:51:21,spid4s,Unknown,Dropping signature from: sp_get_job_alerts

  • how to fix it

    Attachments:
    You must be logged in to view attached files.
  • The file location doesn't exist

    The system cannot find the path specified.

    Ensure the file paths below exist, if not create them, assign permissions and put in the right files

    L:\LogFiles\, L:\LogFiles\Alerts_log.ldf, I:\DataFiles\, I:\DataFiles\Alerts.mdf

     

     

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

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