<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
In Always On HA configuration for SQL 2012 database, is the secondary database in read-write mode or read-only?<br />
<br />
Appreciate your inputs.<br />
<br />
Regards,<br />
Aravind G
</div>
</div>


Hi,

In Always On HA configuration for SQL 2012 database, is the secondary database in read-write mode or read-only?

Appreciate your inputs.

Regards,
Aravind G

Is secondary database read-write in SQL Server 2012 Always on configuration?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft 365 Enterprise E5 is the most feature-rich version of Microsoft 365 and consists of Office 365, Windows 10, and Enterprise Mobility + Security (EMS). It provides the collaboration, productivity, automation, and security features an enterprise customer may need to support its digital business transformation initiatives in a single stock keeping unit (SKU),
which streamlines its deployment and utilization. For companies that do not need the full feature set, Microsoft offers different versions, such as the E3 SKU at a lower price point and F1 for firstline workers.