I am using SQL Server 2017 and SSMS 18.0 Version. During creation of availability group at validation step at primary Server (DBN1), i am facing that error i.e.

the following required directories do not exist on replica DBN2 : C:\Program Files \Microsoft SQL Server\MSSQLSERVER1\MSSQL\DATA enter image description here

How to resolve this issue ??


As per @PinalDave blog here 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.

For further your ref here and here

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.