debugsqlMinor
SQL Availability Group Validation Error
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:
You'll notice that the secondary replica is missing
The fix is to make the secondary have identical paths for the databases involved.
Example:
Primary Replica: Database files are in E:\Mount1\, E:\Mount2\, F:\Mount3
Secondary Replica: Existing directories E:\Mount1\, F:\Mount3You'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:\Mount3Context
StackExchange Database Administrators Q#153407, answer score: 6
Revisions (0)
No revisions yet.