Friday, May 4, 2018

Database is in restoring mode

When a ConfigMgr site database is on SQL always on and failover performed to asynchronous node, then all the synchronous nodes will stay in Restoring mode.
Note: SCCM site database AlwaysOn failover to Asynchronous node is not supported

There is no option to recover the database when it is in restoring state, also no option to take the database offline.
Deletion of the database is only the option.
To delete the database select the database which is tuck in Restoring mode, then right click then select Delete

No comments:

Post a Comment