Introduction
In this article, we will learn how to restore a database which is stuck in the Recovery Pending State. Recently, due to power failures, the disk which contains the transaction log file was failed. Due to that, some of the development databases were entered into the recovery pending state.
To fix the issue, we rebuild the transaction log files and bring the databases online. In this article, I will explain the entire process step-by-step. But before that, first let us understand common reasons when the database entered recovery pending state.
Causes of Recovery Pending State
After restarting the SQL