Always On Database Stuck in Restoring State

Issue:

Always On database stuck in “Restoring” state after setting up Always On

Fix:

Go to Always On High Availability -> Database -> “Join to Availability Group”

Sources:

https://www.mssqltips.com/sqlservertip/5460/sql-server-database-stuck-in-restoring-state/