Category Archives: Always on

SQL Server High Availability and Database Recovery Model Relationship

There are four types of high availability options available in Microsoft SQL server. All the options are different from each other. For example, Log shipping, Mirroring and Always On works on database level while Replication works on database objects level. … Continue reading

Rate this:

Posted in Always on, Database Administration, Replication, Sql Server, T-SQL | Leave a comment

How to add and remove a database to an availability group in Always On

How to add and remove a database to an availability group in Always On Rule: Connect to the server instance that hosts the primary replica. Use the┬áT-SQL statement as below After you add a database to an availability group, you … Continue reading

Rate this:

Posted in Always on, Clustering, Database Administration, T-SQL | Tagged , , , , , , , , , , | Leave a comment

Always On in SQL Server 2017 (Read-Scale Feature)

Always On in SQL Server 2017 (Read-Scale Feature) SQL server 2017 has introduced new feature and technology (read-scale availability group) with Always on. Now, Always On availability groups provide high availability, disaster recovery and read-scale balancing. Read-Scale Availability Group: This … Continue reading

Rate this:

Posted in Always on, Clustering, Database Administration, T-SQL | Tagged , , , , , , , , , | Leave a comment