Forum Discussion

Moe-Alkronz's avatar
Moe-Alkronz
Copper Contributor
Mar 23, 2024

Secondary database is stuck in "restoring" mode after configuring always on high availability

Hello Everyone I'm using SQL server 2019 and i configured always on high availability group, when i checked the database on the secondary server it was stuck in "restoring" mode instead of being in ...
  • Moe-Alkronz's avatar
    Mar 28, 2024

    I found that this happens when carrying out the configuration using SSMS but if i script the always on high availability configuration and run it as TSQL script it works. same thing with DB mirroring.

    I'm using SSMS 18.0, is this a bug?

Resources