HiveBrain v1.2.0
Get Started
← Back to all entries
debugsqlMinor

SQL Availability Group Validation Error

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
errorgroupsqlvalidationavailability

Problem

I am trying to add a replica in a different subnet to my availability group and keep running into an error. I have confirmed the default file locations are the same on both servers but can't figure out why I am getting this error.

Solution

This isn't saying the default file locations need to be the same, this is saying that you don't have identical paths for all files in the database(s) on the secondary server.

Example:

Primary Replica: Database files are in E:\Mount1\, E:\Mount2\, F:\Mount3

Secondary Replica: Existing directories E:\Mount1\, F:\Mount3


You'll notice that the secondary replica is missing E:\Mount2\

The fix is to make the secondary have identical paths for the databases involved.

Code Snippets

Primary Replica: Database files are in E:\Mount1\, E:\Mount2\, F:\Mount3

Secondary Replica: Existing directories E:\Mount1\, F:\Mount3

Context

StackExchange Database Administrators Q#153407, answer score: 6

Revisions (0)

No revisions yet.