July 19, 2017 at 11:44 pm
Hi
We are testing a stange scenario in our company. We have two data centers and we setup alwayson as Active-Passive mode
Here are the testing scenarios
net.exe stop clussvc
net.exe start clussvc /forcequorum
Every thing is fine now.
Can somebody please help me in getting things in normal state when VPN and Primary server is up, as Primary server is also acting as primary.
🙂
July 20, 2017 at 12:21 am
Hi
After you do a failover with allow data loss, the next step is to resume data movement to put the database (secondary replica) in SYNCHRONIZING state.
1. In Object Explorer, connect to the server instance that hosts the availability replica on which you want to resume a database, and expand the server tree.
2. Expand the AlwaysOn High Availability node and the Availability Groups node.
3. Expand the availability group.
4. Expand the Availability Databases node, right-click the database, and click Resume Data Movement.
5. In the Resume Data Movement dialog box, click OK.
Best Regards,
July 20, 2017 at 12:59 am
Thanks Ricky,
Before going to test this this, I would like to reconfirm the below conditions.
My VPN and Primary is still down and I have started clustered forcibly. You suggestion here is to resume the data movement at secondary server. Will every thing will be synced and Primary server will be started as secondary state.. Or I need to take any steps to make it sync.
Main reason I am asking this is previously when I started Primary and after connecting the VPN both servers are showing as primary and working independently without sync.
Please suggest me.
🙂
July 21, 2017 at 5:05 am
Ram:) - Wednesday, July 19, 2017 11:44 PMHi
We are testing a stange scenario in our company. We have two data centers and we setup alwayson as Active-Passive mode
- We disconnected the VPN between 2 datacenters
- Secondary server will goes resolving mode, as expected
- Now we shut down primary as well
- As there is no communication to the secondary, It is still in resolving mode
- We started the cluster forcibly at secondary server.
net.exe stop clussvc
net.exe start clussvc /forcequorum
- And connect the cluster using Failover Cluster Manager
- But still secondary AG is in resolving mode
- Now Failover the AG with allow data loss and it is primary now
Every thing is fine now.
Can somebody please help me in getting things in normal state when VPN and Primary server is up, as Primary server is also acting as primary.
Confirm the replica settings for the AG, synchronous or asynchronous, any auto failover?
At the Windows Server Failover Cluster level, how many nodes in the cluster, what quorum model are you using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply