Health of a databse: Run Eseutil /mh “Path of the database” and check the state of the database.
1. State= Clean Shutdown
Move log files from the Transaction logs folder location and mount the databse
2. State= Dirty Shutdown
Ensure that the log files required is in a Clean state by performing Eseutil /ml “Path of the log fileslog prefix” command
If the health status os ‘OK’ perform the Soft recovery with the command Eseutil /r <Log Prefix> /l “Path of the log files” /d “Path of the database”
Mount the database after completing the operation
Sometimes the ‘/i’ switch is also used when the operation has failed to complete
In the situation where log files are missing, restore from a successful back up or perform Hard repair
Once the restoration completes, a file named restore.env along with the logs that were backed up without being committed to the database will be created in C:Temp
Perform Hard Recovery by the command Eseutil /cc “Path of the restore.env containing folder”
restore.env file will be deleted after the completion of hard recovery
If we misses the sequence of logs, the recovery will fail and should use the command eseutil /cc “Path of the restore.env folder” /t to recover the databse
Use eseutil /p “path of edb file”
Once Eseutil /p finishes we will need to defrag the databases. You must have available hard disk space equal to 110 percent of the size of the database that you want to defragment.