Symptoms

K2 Workspace loads but returns an error message "Preinit Membership" verification fail. The K2 Database Transaction Log file (K2_log_1.ldf) is at 95% of the main disk drive usage. When trying to look at it in SQL Server Management Studio, K2 database is in - "Recovery Pending" state.
 

Diagnoses

The database is showing in ‘Recovery Pending’ state, it means that the recovery cannot be started. Until the cause is get fixed, recovery can’t run and the database can’t come online. One of the reasons of this SQL Servber behavior,
-MDF file got corrupted
-Not enough space available for the SQL Server to recover the database during startup (turned out the .LDF file is used 95% of the main disk drive).
 

Resolution

The steps below are taken to get the K2 database back online and K2 Blackpearl server service started successfully.
i) Check that the K2 MDF and LDF files are still existed in MSQL folder.
ii) Stop the SQL service from SQL Configuration Manager and free up some space on the main drive, make sure there is enough space there for the recovery to complete.
iii) Now restart SQL service and K2 database is back online mode.