I have a 2-node SQL Server AlwaysOn Availability Group. When I execute this T-SQL command on the Primary server:
ALTER AVAILABILITY GROUP MyAG REMOVE DATABASE TestDB
it removes the
TestDB from the Availability Group. Everything looks fine on the Primary server. However, on the Secondary replica, the
TestDB has the status of "Restoring ..." next to it. The database is inaccessible. The status remains "Restoring..." for a while. Looks like the only thing I could do is to drop it, which I did.
My question is: after I remove the DB from MyAG, what do I need to do to make the
TestDB available for use again on the secondary replica?