Database is Stuck in (Principal, Disconnected / In Recovery)

Plesk Servers > SQL > MSSQL
Database is Stuck in (Principal, Disconnected / In Recovery)

Issue
Database is not accessible and is listed as "(Principal, Disconnected / In Recovery)".

Possible Cause
This may happen if database server is abruptly power cycled or rebooted.

Resolution
  1. Remote Desktop and log into the database server.
  2. Start SQL Server Management Studio.
  3. Right-click on your database and select Properties.
  4. Click on the Mirroring page and then click the Failover button.
  5. The database will now be listed as (Mirror, Synchronized / Restoring) and will be accessible from the other MS SQL Server
 

Add Feedback