Unable to start Availability group role. error code 0x8007139a

Question

Unable to start Availability group role. error code 0x8007139a

ricardo_chicas

SSCertifiable

Points: 5024
More actions
May 11, 2018 at 12:41 pm

#338041

Hello, we have a sql server 20012, latest service pack on a 2 node sql cluster with 1 availability group
after a reboot today we are unable to start the AG role and all we get is error code 0x8007139a, so far I've been unable to find the real error behind it and it is urgent to recover.
any help will be appreciated

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

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

Sue_H SSC Guru Points: 90860 More actions · Answer 1

ricardo_chicas - Friday, May 11, 2018 12:41 PM
Hello, we have a sql server 20012, latest service pack on a 2 node sql cluster with 1 availability group
after a reboot today we are unable to start the AG role and all we get is error code 0x8007139a, so far I've been unable to find the real error behind it and it is urgent to recover.
any help will be appreciated

That looks to be coming from the cluster - check the resources possible owners, dependencies, etc. It's usually related to that. The cluster log would likely have more information.

Sue

ricardo_chicas SSCertifiable Points: 5024 More actions · Answer 2

Sue_H - Friday, May 11, 2018 3:30 PM
ricardo_chicas - Friday, May 11, 2018 12:41 PM
Hello, we have a sql server 20012, latest service pack on a 2 node sql cluster with 1 availability group
after a reboot today we are unable to start the AG role and all we get is error code 0x8007139a, so far I've been unable to find the real error behind it and it is urgent to recover.
any help will be appreciated
That looks to be coming from the cluster - check the resources possible owners, dependencies, etc. It's usually related to that. The cluster log would likely have more information.
Sue

Where can I see the cluster log?

PretendDBA SSCrazy Points: 2060 More actions · Answer 3

If you go into the cluster management console. It's the bottom tab.

ricardo_chicas SSCertifiable Points: 5024 More actions · Answer 4

PretendDBA - Sunday, May 13, 2018 5:24 PM
If you go into the cluster management console. It's the bottom tab.

Thanks, there was nothing there or at any of the log files, MS really dropped the ball at providing useful info in these cases. In the end I was forced to rebuild the cluster