SQL Server 2012 Availability Group Failover
Posted on 2014-02-14
I have an SQL Server 2012 Availability Group set up across two data centers. The Availability Group has five databases in it. I have a process that begins to load data into one of the databases on the primary replica. When I failover the availability group and make the secondary replica primary, the process reports that the database is read only. In addition, if I begin a new process attempting to load data to the new primary replica (I haven't failed the AG back yet) I get the same error, database is read only. I can't figure out how to make my secondary databases writable in case of an automatic failover. I believe I have all the pre-requisits taken care of. I've tried to alter the read intent of the secondary databases using the the availability group wizard but I still get the same result. Any help is appreciated.