Dynamics 365 Microsoft Power Platform Cloud and Productivity Apps
Sales
Streamline sales and improve customer relationships
Project Operations
Managing projects, resources and finances efficiently
Finance
Improve operational efficiency and financial planning
Marketing
Optimizing marketing efforts and enhancing customer connections
Field Service
Optimizing on-site service and field operations
Customer Service
Managing customer interactions and resolving issues efficiently
Supply Chain
Automating and managing the end-to-end supply chain efficiently
Business Central
Unify financials, operations and customer management
Power BI
Visualizing data to support strategic business decisions
Power Apps
Low-code apps for faster, mobile, cost-effective innovation
Microsoft Azure
Flexible, secure hybrid cloud with extensive services
Microsoft 365
Collaboration tools for improved business performance
Iot and Machine Learning
Transform device data into actionable insights
This might be useful
Sales Project Operations Marketing
Logistics and Transportation Manufacturing Companies Construction Suppliers Energy Companies Health Care Non-Governmental Organizations Professional Services Business Consulting IT Consulting Software Companies Private Equity
Industry and services
The ideal digital transformation partner is not only an expert in theory and technology but also in its customer’s industry. Our consultants are familiar with the processes, priorities and challenges of these eight focus industries.
Contact us
Manufacturing companies
proMX has long been focused on supporting manufacturing companies with their digital transformation.
Consulting Services Implementation Services Digital Transformation Workshops
proMX services
proMX helps you tackle challenges by analyzing your processes and customizing your system with tailored solutions. In our discovery workshop, we'll pinpoint the right tools to boost productivity. Let’s get started!
This might be useful
Project Operations Sales
proMX 365 Productivity Suite Dynamics 365 apps
Project Portfolio Management
Enhancing project performance and resource utilization
Time Tracking
Enhances time and expense tracking
Mobile Time Tracking
Outlook integration, mobile access, and organized task overviews
Absence Management
Streamlined absence management with automated tracking
proMX 365 Core
Сustomizable tools for tailored project management
proRM Fast Start
Efficient project management for SMBs
This might be useful
Logistic and Transportation Energy Professional Services
Why partner with proMX? Partner benefits Partner Program​
Partners
Partnering with proMX Group to offer the proMX 365 Productivity Suite provides a unique opportunity to enhance your business portfolio and drive significant growth.
Become a Partner
Our mission
All companies strive to digitalize and optimize their processes, and thus become more productive.
Career Team Gallery Events Social responsibility Offices worldwide Contact
About us
proMX is your digitalization partner. Our goal is to help you transform your processes to make your business more agile, efficient and competitive. As a Microsoft Partner we are both extremely experienced and well-connected.
More about proMX
Our mission
All companies strive to digitalize and optimize their processes, and thus become more productive.
DEEN
Home › Blog › Microsoft SQL Server: Database Repair following “Recovery Pending“ Status

Microsoft SQL Server: Database Repair following “Recovery Pending“ Status

Armin Odorfer
Nov 22, 2016 | Last updated: Dec 16, 2022
Expert articles | 3 min read

In a database system, sufficient free storage space on the data bank partition is important. In addition to regular database back-ups, it is therefore wise to monitor the free storage space.

When your database partition is full, the Microsoft SQL server sets the status of the database that can no longer grow to “Recovery Pending”. This status means that SQL can’t open the database and can’t lock the database files. This status is comparable to a database in offline modus.

When a database partition is full the status of the SQL server database is set to “Recovery Pending.”

Repair recovery pending SQL server database in 9 steps

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

  1. Increase the available storage space.
  2. Create back-ups of database files *.mdf (Primary Data File), *.ndf (Secondary Data Files, if available) and *.ldf (Log Files).
  3. Set the database to mode “online“:
    ALTER DATABASE MX_MSCRM SET ONLINE
  4. Run CheckDB against the database in question (only warnings):
    DBCC CHECKDB(‘MX_MSCRM’) WITH NO_INFOMSGSIf CheckDB has completed without warning, the database does not need to be repaired.Otherwise proceed to step #5.
  5. Before repair, the database has to be set to single user mode:
    ALTER DATABASE MX_MSCRM SET SINGLE_USER
  6. 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).
  7. 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).
  8. 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
  9. 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.
6
After performing the steps above, the status “Recovery Pending” disappears.

Here you can learn more about SQL database in recovery pending state.

⨯

Answering