SQL Server – Availability Group Issue

Spent part of a day chasing down an SQL Server Always On Availability Group manual failover, failure issue.

When running the failover wizard, the failure looks like this:

SNAGHTML445909

Some of the error description: Manual failover failed. Failed to perform a manual failover of the availability group ‘x’ to server instance ‘y’. Error code 5015.

Resolution:

The Availability Group and the Listener Name were named identically. That was causing the failure, to Windows Cluster, it was a name conflict as both resources could not be shared.

Renamed the AG name, problem solved!

Advertisements
This entry was posted in High Availability, SQL Server. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s