Browse by Tags

Blog Post: Common issues faced while configuring AlwaysOn listener on Azure VM cluster

SQL Server Support Content

We have MSDN article [Tutorial: Listener Configuration for AlwaysOn Availability Groups ( http://msdn.microsoft.com/en-us/library/dn425027.aspx ) which provides detailed steps to configure AlwaysOn listener on Azure VM cluster. This article provides steps ...read more

on 22 Dec 2014
Blog Post: VSS backup of AlwaysOn Secondaries

SQL Server Support Content

Hi Everyone, Today I’m going to highlight one of the changes brought by SQL Server 2012 SP2 , which is the way we handle VSS Backup requests on AlwaysOn Secondary Databases . Until now, any request for a FULL database backup (VSS_BT_FULL) thru VSS against ...read more

on 12 Aug 2014
Blog Post: How to move databases configured for SQL Server AlwaysOn

SQL Server Support Content

How to move databases configured for SQL Server AlwaysOn This article describes how to change the location of the data files and the log files for any Microsoft SQL Server 2012 database which are configured with SQL Server AlwaysOn with minimal ...read more

on 6 Feb 2014
Blog Post: AlwaysOn ERROR: Log backup for database "MyDB" on secondary replica created backup files successfully but could not ensure that a backup point has been committed on the primary.

SQL Server Support Content

This error surprised me when it showed up in the error log so I decided to dig into it a bit more. “Log backup for database "MyDB" on secondary replica created backup files successfully but could not ensure that a backup point has been committed ...read more

on 5 Dec 2012
Blog Post: How to configure Always On for a TDE database

SQL Server Support Content

Before you configure Always On for a TDE database make sure the following pre requisites are followed. 1. Always On endpoint port is opened in all node (5022 is default port, which can be changed). 2. Startup account of ...read more

on 22 Nov 2013
Blog Post: How It Works: SQL Server AlwaysOn Lease Timeout

SQL Server Support Content

The lease is used between the SQL Server resource DLL and the SQL Server instance to prevent split-brain from occurring for the availability group (AG). The lease is a standard signaling mechanism between the SQL Server resource DLL and the SQL Server ...read more

on 7 Sep 2012
Blog Post: AlwaysON - HADRON Learning Series: lock_redo_blocked/redo worker Blocked on Secondary Replica

SQL Server Support Content

The topic I received most in my inbox this week was redo blocked on a secondary while attempting to acquire SCH-M (schema modify) lock. First of all, this is expected behavior and you can monitor for this with your standard blocking activities (sys.dm_exec_requests ...read more

on 26 Apr 2013
Blog Post: How It Works: Always On–When Is My Secondary Failover Ready?

SQL Server Support Content

I keep running into the question: “When will my secondary allow automatic failover?” Based on the question I did some extended research and I will try to summarize in is blog post. I don’t want to turn this post into a novel so I am ...read more

on 22 Apr 2013
Blog Post: AlwaysON - HADRON Learning Series: HADR_SYNC_COMMIT vs WRITELOG wait

SQL Server Support Content

The distinction between these two wait types is subtle but very helpful in tuning your Always On environment. The committing of a transaction means the log block must be written locally as well as remotely for synchronous replicas. When in ...read more

on 26 Apr 2013
Blog Post: INF: AlwaysON – The secondary database doesn't come automatically when the primary instance of SQL Server goes down

SQL Server Support Content

In this blog we would discuss about behavior of AlwaysON where the secondary database doesn't come automatically when the primary instance goes down. The secondary database goes into Resolving state. On the failover cluster manager the resource appears ...read more

on 15 Mar 2012

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?

SQL Server KBs and Blogs

Browse by Tags

Blog Post: Common issues faced while configuring AlwaysOn listener on Azure VM cluster

Blog Post: VSS backup of AlwaysOn Secondaries

Blog Post: How to move databases configured for SQL Server AlwaysOn

Blog Post: AlwaysOn ERROR: Log backup for database "MyDB" on secondary replica created backup files successfully but could not ensure that a backup point has been committed on the primary.

Blog Post: How to configure Always On for a TDE database

Blog Post: How It Works: SQL Server AlwaysOn Lease Timeout

Blog Post: AlwaysON - HADRON Learning Series: lock_redo_blocked/redo worker Blocked on Secondary Replica

Blog Post: How It Works: Always On–When Is My Secondary Failover Ready?

Blog Post: AlwaysON - HADRON Learning Series: HADR_SYNC_COMMIT vs WRITELOG wait

Blog Post: INF: AlwaysON – The secondary database doesn't come automatically when the primary instance of SQL Server goes down