SQL Database Recovery Pending

SQL Database Recovery Pending

** Note: Before attempting any of the below, verify that:

-No low/no storage space issues on the drive storing the database
-No issues with the services related to SQL
-No recent reboots of the SQL/host server
-No hardware failure/issues
-No issues with low memory

_________________________________________________________________________________________________
_________________________________________________________________________________________________

In a scenario with a Recovery Pending on a database and varied issues within the software accessing the database (depending on what functions the database would normally handle), use the following instructions to resolve the Recovery Pending state:

(The information below is pulled from the link at the bottom of the KB.)

5

"In most cases, the following steps will repair the database (in this example: MX_MSCRM):

• Increase the available storage space.

• Create back-ups of database files *.mdf (Primary Data File), *.ndf (Secondary Data Files, if available) and *.ldf (Log Files).

• Set the database to mode “online“:
ALTER DATABASE MX_MSCRM SET ONLINE

• Run CheckDB against the database in question (only warnings):
DBCC CHECKDB(‘MX_MSCRM’) WITH NO_INFOMSGS        If CheckDB has completed without warning, the database does not need to be repaired.Otherwise proceed to step #5

• Before repair, the database has to be set to single user mode:
ALTER DATABASE MX_MSCRM SET SINGLE_USER

• There are different repair levels. Usually, one begins with “REPAIR_REBUILD“:
DBCC CHECKDB(‘MX_MSCRM’,REPAIR_REBUILD)               If the repair is successful, the database may be set back to multiple user mode (see step #9).

• Otherwise, repair level “REPAIR_ALLOW_DATA_LOSS” is next. Please note that (as the name suggests) this may result in a loss of data:
DBCC CHECKDB(‘MX_MSCRM’,REPAIR_ALLOW_DATA_LOSS)              If repair was successful, the database may be set back to multiple user status (see step #9).

• Finally, you can try repair via the “EMERGENCY“ mode:
ALTER DATABASE MX_MSCRM SET EMERGENCY
ALTER DATABASE MX_MSCRM SET SINGLE_USER
DBCC CHECKDB (MX_MSCRM,REPAIR_ALLOW_DATA_LOSS) WITH
NO_INFOMSGS,ALL_ERRORMSGS

• Set database to status “Online” and re-activate multiple user mode:
ALTER DATABASE MX_MSCRM SET ONLINE
ALTER DATABASE MX_MSCRM SET MULTI_USER                If everything worked out, the status “Recovery Pending“ should disappear after refreshing.>"




    • Related Articles

    • Sage - New Fiscal Year

      Log into the database with a user with Sage 300 ERP admin rights. Double-click on Common Services. Double-click Fiscal Calendar. Select the appropriate year. Double-click on the field Unlock Column for the period to be unlocked. Repeat step 5 for ...

    • Setup Exchange on Outlook for Android

      Copy and Paste into email to user. Open Outlook App, enter your full email address and click Continue. Select Exchange as your account type. Enter your email address, password and a name for the account (for example Exchange) and tap on ADVANCED ...

    • Meraki macOS VPN Setup

      USE THIS TO COPY AND PASTE AS A GUIDE Open System Preferences > Network from Mac applications menu.  Click the "+" button to create a new service, then select VPN as the interface type, and choose L2TP over IPsec from the pull-down menu. Server ...

    • Remote Desktop DPI Scaling Fix

      Problem Description:  Small text, icons, and menus are displayed when users connect to their office computer or the RDS server using Remote Desktop. Solution: The steps need to be completed on the main/personal computer and not the remote/office ...

    • How do I reset my password when connected to my network remotely?

      Most corporate networks have a password policy that requires periodic resets. When you are working remotely this can be a challenge because of the way that password resets are communicated to your servers on your corporate network. Scenario 1: I am ...