SQLTeam.com | Weblogs | Forums

Recovery Pending

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 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 this issue

This happens when you are doing what?

i have restarted machine and after that facing this issue.

please help me

this happens when i do restart server. now issue has been fixed . by taking offline and online database