This blog is about another message which I faced with I faced in the wizard. You can read earlier two blogs with more problems which my client faced. This error is about AlwaysOn Wizard Error.
After fixing above two messages, now we faced below error in “Validation” phase of the wizard.
Checking for compatibility of the database file locations on the server instance that hosts secondary replica SQLAUTHNODE2 (Microsoft.SqlServer.Management.HadrModel)
When my client checked, they were having correct drives on both the servers and they were worried about the cause of the error.
WORKAROUND/SOLUTION
I explained my client that the wizard looks at the exact same folder path. Here is the query to find exact path.
SELECT DB_NAME(database_id), physical_name FROM SYS.MASTER_FILES
We need to make sure that the path exists on secondary replica, not just drive letter.
Once we created path, issue was resolved, and we were able to move forward.
Have you come across any such error in validation? I would be very interested to know if you have faced this error previously.
Reference: Pinal Dave (https://blog.sqlauthority.com)
4 Comments. Leave new
THANKS lot bro
How about if reploica is named second instance
How do you match Match file location on both the instances ?
Interesting problem:
TITLE: Microsoft SQL Server Management Studio
——————————
The following required directories do not exist on replica Replica2 :
\\Replica1\E$\Data,
\\Replica1\L$\Log.
(Microsoft.SqlServer.Management.HadrModel)
——————————
SELECT DB_NAME(database_id), physical_name FROM SYS.MASTER_FILES
indeed showed me that \\Replica1\E$ was in the actual physical filename.
Changed it to resp E:\ and L:\ And the AG Add database wizards worked like a charm.