Exit from "Not Synchronising" Primary Database in availibility Group

Question

Post reply

Exit from "Not Synchronising" Primary Database in availibility Group

sm_iransoftware

Ten Centuries

Points: 1228
More actions
January 27, 2015 at 6:52 am

#314069

Hi
I Create an availibility Group with a primary and a secondary. (For test)
Then run Planed Failover.
Switched to secondary. That's ok.
After that I update some tables on secondary (That now is primary)
I Run Again Planed Failover on server 2.
Switched. OK
But primary database Get (Not synchronising) Status.
And in primary I dont have that updates.
How to sync these databases and exit from Not synchrionysing.
Thank you

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 234013 More actions · Answer 1

what are the synch modes set on the replicas?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

sm_iransoftware Ten Centuries Points: 1228 More actions · Answer 2

sm_iransoftware

Ten Centuries

Points: 1228

January 28, 2015 at 12:00 am

#1773577

Automatic sync

Perry Whittle SSC Guru Points: 234013 More actions · Answer 3

what does the dashboard show?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

PHXHoward SSCrazy Eights Points: 8389 More actions · Answer 4

There is a known issue with the newest cumulative updates that can cause this. Are you on that patch version?

http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/01/21/alwayson-availability-groups-may-be-reported-as-not-synchronizing-after-you-apply-sql2012-sp2-cu3-or-sql2012-sp2-cu4-or-sql2014-cu5.aspx

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 5

sm_iransoftware (1/27/2015)
Hi
I Create an availibility Group with a primary and a secondary. (For test)
Then run Planed Failover.
Switched to secondary. That's ok.
After that I update some tables on secondary (That now is primary)
I Run Again Planed Failover on server 2.
Switched. OK
But primary database Get (Not synchronising) Status.
And in primary I dont have that updates.
How to sync these databases and exit from Not synchrionysing.
Thank you

Wait and see the sync status. Also read the error log.

You can alter the AG database with resume.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/