Alwayson availability group setup, Checking for compatibility of the database file location on the secondary replica resulted in an error

Hi Friends,

Few days back I received a call from one of my friend mentioning that he ran into an issue while alwayson availability group setup. He did add two replicas successfully but at the time of validation, configuration wizard failed with following error (I’ve pasted error screenshot as well);

Checking for compatibility of the database file location on the secondary replica resulted in an error. (Microsoft.SqlServer.Management.HadrTasks)

1_SQL_Server_Checking_for_compatibility_of_the_database_file_location_on_the_secondary

My friend used ‘Full’ option in Select Initial Data Synchronization Page. From error message it is clear that, Primary replica is trying to search for data folder location in secondary and as a result they don’t match, setup failed. There are two different ways to address the issue i.e. EITHER;

   

1. Match file location on both the instances if ‘Full’ option is selected on ‘Select Initial Data Synchronization Page’

OR;

2. Manually sync the data by backup/restore in secondary then select ‘Join Only’ option in ‘Select Initial Data Synchronization Page’

We decided to Prepare Secondary Database Manually then used ‘Join’ option in ‘Select Initial Data Synchronization’ Page and configuration went fine. You can refer MSDN to know further on Select Initial Data Synchronization.

Regards

Kanchan Bhattacharyya

Like us on FaceBook Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook

Follow me on TwitterFollow me on FaceBook

   

About Kanchan Bhattacharyya

Kanchan is an astute IT professional, a seasoned SQL Database Administrator with 13+ years of industry experience. A calculated risk taker with deep technical knowledge and has gained proficiency in database consulting and solutions across different environments. Kanchan holds MBA degree in IT and an International Executive MBA in Project Management. He is very passionate about SQL Server and holds MCSE (Data Platform), MCSA – SQL 2012, MCITP – SQL 2008 certifications. Currently he is focusing on cloud and latest releases of SQL Server. When not working, Kanchan likes to spend his time reading on new technical developments specifically on SQL Server and other related technologies.

View all posts by Kanchan Bhattacharyya →

One Comment on “Alwayson availability group setup, Checking for compatibility of the database file location on the secondary replica resulted in an error”

  1. Kanchan Bhattacharyya

    How do I enable AlwaysOn high availability within the Configuration manager, it is giving the following message requires the x86 (non-Wow) or x64 Enterprise Edition of SQL Server 2012 (or later version) with WSFC hotfix KB 2494036 installed, and I am using Windows Server 2008r2 sp1 with SQL Server 2014 and applied to the requested hotfix, most did not work, one would have any idea what you can do to solve this problem?

Leave a Reply

Your email address will not be published.