How to fix Recovery Pending State in SQL Server Database?
![Powershell restart server Powershell restart server](/uploads/1/2/5/5/125543778/547754928.png)
318k5050 gold badges488488 silver badges592592 bronze badges
Mahesh Thorat Mahesh Thorat
4 Answers
Dec 29, 2017 Using Configuration Manager console, you can now identify client devices that require a restart. Post then you use a client notification action to restart those client devices.SCCM 1710 Restart Client Feature, SCCM 1710 Restart Client Devices Values,what is this SCCM 1710 Restart Client Feature. Restarting WebSphere Application Server. WebSphere® Application Server can be restarted in a number of ways. After performing some operations in either the WebSphere Application Server administrative console or the Tivoli® Federated Identity Manager administration console, you must restart WebSphere Application Server to apply your changes.
Execute the following set of queries:
For more info: https://www.stellarinfo.com/blog/fix-sql-database-recovery-pending-state-issue/
a_horse_with_no_name318k5050 gold badges488488 silver badges592592 bronze badges
Mahesh Thorat Mahesh Thorat
There are two manual solutions to fix database pending status.1. Label database in Emergency mode and start forceful Repair2. First label the database in Emergency mode, then detach the main database and re-attach it to the server.
For More Info: https://community.spiceworks.com/how_to/157233-how-to-fix-recovery-pending-state-in-sql-server-database
selinajodiselinajodi
Execute the following set of queries:
ALTER DATABASE [DBName] SET EMERGENCY; GO
ALTER DATABASE [DBName] set single_user GO
DBCC CHECKDB ([DBName], REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS; GO
ALTER DATABASE [DBName] set multi_user GO For more info: https://www.stellarinfo.com/blog/fix-sql-database-recovery-pending-state-issue/
This solution worked for me. Thanks for sharing.
PriyankaPriyanka
When your Database .mdf file name is renamed, this issue is occurred. To solve:
Restart SQL EXPRESS in Services, Pending issue is solved.
Kaviya MahadevanKaviya Mahadevan