May 28, 2015 at 10:32 am
Greetings! I experienced an issue and I am having trouble finding documentation that goes into depth here. I am hoping someone here might be able share some information or point me to documentation.
The secondary server for my availability group was recycled. When SQL Server came back online the data movement for a database was suspended. The error log shows:
"AlwaysOn Availability Groups data movement for database 'XXXXXXXXX' has been suspended for the following reason: "system" (Source ID 5; Source string: 'SUSPEND_FROM_RESTART'). To resume data movement on the database, you will need to resume the database manually. For information about how to resume an availability database, see SQL Server Books Online."
I was able to resume data movement with no issue. I would like to understand the technical reason as to WHY the data movement was put in the suspended state and left there upon recycle. I searched for an article that would list possible reasons (BOL, Google, Bing, etc..). I just could not find much information out there on 'SUSPEND_FROM_RESTART'.
Thank you for any information you have to share!
Kim
May 28, 2015 at 10:43 am
Quick thought, search for "AlwaysOn Availability Groups data movement for database 'XXXXXXXXX' has been suspended"
😎
Edit: typo
May 28, 2015 at 11:42 am
Did you check out this: Resume an Availability Database (SQL Server)?
😎
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply