Category Archives: High Availability

TSQL to add a database to existing Availability group

Following are the TSQL statements that can be used to add database into existing Availability group. Advertisements

Posted in High Availability, Productivity, SQL, SQL Server, Uncategorized | Tagged , , , | Leave a comment

How to give access to Users in Secondary Always-On/Mirror Server

When we need to provide access to users on a secondary database we will be able to create a login but not user on the read-only database. To address the problem we need to create the Login with same SID … Continue reading

Posted in High Availability, SQL, SQL Query, SQL Server, Uncategorized | Tagged , , , , , | Leave a comment

AlwaysOn Availability Groups notes

AlwaysOn can broadly categorized into 2 (AlwaysOn Failover Cluster Instances, and AlwaysOn Availability Groups). I will capture Availability group highlights… AlwaysOn Failover Cluster Instances: failover cluster instance (FCI) is a single instance of SQL Server that is installed across Windows … Continue reading

Posted in High Availability, SQL Server | Tagged , , | Leave a comment