Category Archives: High Availability

Availability Group Fail Over date/time – TSQL

I have been using this quick script to verify AG Status Change details from error log. Advertisements

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

Error Creating Availability Group – Error: 41042 (Fixed)

While Building 50 Servers with 10 AG Groups in each Server we had to uninstall SQL and re-install again to address one of the server configuration issue. While re-installing we had challenges creating the availability group. Final solution is to … Continue reading

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

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.

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