Recovery Pending

SQL Server Administration
1

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

2

how to fix this issue
??

3

This happens when you are doing what?

5

i have restarted machine and after that facing this issue.

6

please help me

7

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

8

Hello Friends,

As a DBA I know, SQL Recovery pending is critical for any DBA is & It not easy to fix.

The reasons for the SQL recovery pending are mentioned below.

  • Database not shut down properly
  • User tries to move files from one drive another drive
  • Due to insufficient memory space or disk space.

Solution- Mark your SQL database in Emergency mode. Detach and re-attach the main database.

ALTER DATABASE [DBName] SET EMERGENCY;

ALTER DATABASE [DBName] set multi_user

EXEC sp_detach_db ‘[DBName]’

EXEC sp_attach_single_file_db @DBName = ‘[DBName]’, @physname = N'[mdf path]’

Good Luck

1 Like