Tags » AlwaysOn

How to monitor Timeout and Changes Roles from Availability Groups with Alerts

Agent alert can send alerts by email when occur some action/timeout between databases in your Availability Group Environment. It allows you to become proactive.

The following script shows how to create these alerts. 341 more words


Replicate logins and jobs in #SQLServer #AlwaysOn environments

After working for a while with SQl 2012 and AlwaysOn it becomes clear that keeping logins, jobs and other uncontained objects in sync between different hosts is a problem. 130 more words


SQL Server - Failed to bring availability group '[availability group name]' online

I have been noticing one very common error that occurs while trying to failover an Availability Group in SQL Server 2012 AlwaysON setup. The Availability Group fails to come online during a fail over process. 280 more words

SQL Server 2012

Cireson Portal and SQL AlwaysOn Availability Databases

I have for a while been working on my System Center Service Manager environment to run on Azure Virtual Machines, and to increase availability for this environment I have created a SQL Server AlwaysOn Cluster also in Azure. 1,345 more words


How to validate Quorum Vote from Windows server Failover Cluster (AlwaysOn)

If you have configured a Windows server Failover Cluster with more than two Nodes, you must take care about with the votes in each Node. 265 more words


How to backup database using NetApp SnapManager for SQL - Log shipping, Database Mirroring or SQL AlwaysOn configuration

In this post I will cover the process of configuring a backup of  SQL database  involved in Log shipping, Database Mirroring or SQL AlwaysOn Configuration when using NetApp SnapManager for SQL. 503 more words


How to Monitor AlwaysON - Primary / Secondary Replicas

Last month I developed a procedure to run in a SQL Server Agent Job, to monitor the synchronism status of the AlwaysOn Availability Groups.
In case of “NO HEALTHY” status, the SP will send an email providing details of every databases. 848 more words