SQL Server – How to Resolve Secondary Replica Database Stuck in Restoring Mode

availability-groupsbackuphigh-availabilityrestoresql-server-2019

I created an AlwaysOn in SQL Server 2019 and I selected the Full Database and Log Backup option. Now it created a database in secondary replica but it is still in Restoring mode. My DB size is 16MB and it is very small just for test.
What is the problem?

Best Answer

I found the solution. It is because my account doesn't have sufficient permission.