July 30, 2015 at 5:08 pm
I have a 2 node cluster on server 2012r2/sql2014. Recent patching (thanks MS) took down one of the nodes hard. The second one won't come out of the Resolving state. Any ideas?
There is an exception to every rule, except this one...
July 30, 2015 at 7:47 pm
We have lots tickets with MS re AlwaysOn
even you leave the current status for them remote in to investigate, they will say not enough information.
Here are my summary to fix Alwayson.
1. ALTER DATABASE [DatabaseName] SET HADR RESUME;
If it doesn't work see below.
2. Change sync mode
USE [master]
GO
ALTER AVAILABILITY GROUP [AG]
MODIFY REPLICA ON N'SQLServer\INSTANCE3' WITH (AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT)
GO
USE [master]
GO
ALTER AVAILABILITY GROUP [AG]
MODIFY REPLICA ON N'SQLServer\INSTANCE3' WITH (AVAILABILITY_MODE = SYNCHRONOUS_COMMIT)
GO
If still not working, try 3:
3. remove db from AG, then add it back.
ALTER DATABASE [DatabaseName] SET HADR OFF;
GO
alter database [DatabaseName] set HADR AVAILABILITY GROUP = [AG]
go
If 3 still not work, rebuild the AG, 4:
4. Drop database and restore from scratch.
ALTER DATABASE [DatabaseName] SET HADR OFF;
GO
drop database [OdysseyXXXYYY]
restore database DatabaseName from disk = '\Restored\DatabaseName' with norecovery
restore log DatabaseName from disk = 'Restored\DatabaseName_latest.trn' with norecovery
join the database to AG now.
July 31, 2015 at 5:16 am
SQLHeap (7/30/2015)
I have a 2 node cluster on server 2012r2/sql2014. Recent patching (thanks MS) took down one of the nodes hard. The second one won't come out of the Resolving state. Any ideas?
I believe this is related to a particular patch being installed, cant remember which one now, if I find it i'll post the link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 31, 2015 at 7:50 am
Update: we had to drop the AG alltogether and restart the server.:angry:
There is an exception to every rule, except this one...
July 31, 2015 at 7:51 am
Oh ya, and I do appreciate the responses!
There is an exception to every rule, except this one...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply