Monday 5 February 2018

SQL Database in Recovering state

If you need to re-create your SQL AlwaysON cluster and the database goes into "recovering" state, after you delete the Availability Group.

Run the following T-SQL query on "master" database:
RESTORE DATABASE databaseName WITH RECOVERY
Posted by at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)