Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag AlwaysOn Rss

Search for any content tagged alwayson

   Items 1 to 20 of 41    Older >>
 

Resolving an Error When Creating an Availability Group Listener

In this post, I’m going to talk an issue that I found when creating an availability group listener by using SQL Server Management Studio's Add Listener. This article helps you to resolve the issue.   Read more...
By Ganapathi varma 2016/09/06 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 586 reads

Installing Master Data Services in an AlwaysOn Environment

This article describes a solution for Master Data Service (MDS) hosted on AlwaysOn Availability Group configuration. The article describes how to install and configure SQL 2016 Master Data Services on a SQL 2016 AlwaysOn Availability group (AG). The main purpose of this solution is to improve high availability and disaster recovery of MDS backend data hosted on a SQL Server database.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,852 reads

SQL Server AlwaysOn Endpoint Encryption Algorithm Compatibility Error

Ahmad Yaseen takes a look at how to deal with an endpoint encryption compatibility error when using SQL Server's AlwaysOn Availability Group Wizard.  Read more...
By Additional Articles 2016/06/08 | Source: MSSQLTips.com | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 2,311 reads

Why Every SQL Server Installation Should Be a Cluster

In this article, I’ll attempt to “convince” you that every SQL Server you put into production should be a SQL Server Failover Cluster Instance (FCI).  Read more...
By Francis Apel 2016/03/25 (first published: 2014/04/15) | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 12,924 reads

Stairway to AlwaysOn Level 8: Segregate Mirror Traffic in AlwaysOn

this article details how to segregate the mirror traffic in an AlwaysOn group configuration  Read more...
By Perry Whittle 2016/03/09 | Source: SQLServerCentral.com | Category: alwayson
Rating: (not yet rated) |  Discuss |   Briefcase | 1,314 reads

Stairway to AlwaysOn Level 1: What is "SQL Server AlwaysOn"?

Level 1 of the stairway looks at exactly what the technologies "AlwaysOn", "Failover Cluster Instance" (FCI) and "Windows Server Failover Cluster" are. We'll look at each in detail and summarize where in the High Availability stack they sit.  Read more...
By Perry Whittle 2016/02/24 (first published: 2014/09/24) | Source: SQLServerCentral.com | Category: failover clustered instance (fci)
Rating: |  Discuss |   Briefcase | 17,003 reads

Enabling TDE on Databases in an AlwaysOn Scenario

Enabling Transparent Data Encryption on Databases in Always On Scenario  Read more...
By Sanjiv Doshetty 2016/02/09 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 2,090 reads

Read-Only Routing for Non-Microsoft Clients

An alternative read-only routing technique for non-Microsoft clients.  Read more...
By Chad Feghali 2015/12/28 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 2,133 reads

Learning Always On

References and links to help you learn about the AlwaysOn technologies.  Read more...
By Site Owners 2015/07/20 | Source: SQLServerCentral.com | Category: alwayson
Rating: (not yet rated) |  Discuss |   Briefcase | 2,555 reads

Stairway to AlwaysOn Level 7: Combining FCIs with Availability Groups

In Level 7 of this stairway, we look at combining Availability Groups with FCIs for both HA and DR protection.  Read more...
By Perry Whittle 2015/07/01 | Source: SQLServerCentral.com | Category: high availability
Rating: |  Discuss |   Briefcase | 2,992 reads

Stairway to AlwaysOn Level 6: Analyse & Deploy an AlwaysOn Availability Group

In level 6 of this stairway, we will look deeper into Availability Groups and how to set them up along with a Listener.  Read more...
By Perry Whittle 2015/03/25 | Source: SQLServerCentral.com | Category: stairway
Rating: |  Discuss |   Briefcase | 4,724 reads

Stairway to AlwaysOn Level 5: Analyse & Deploy a Failover Cluster Instance

In Level 5 of this stairway, we help you understand and deploy a Failover Cluster Instance (FCI).  Read more...
By Perry Whittle 2015/02/11 | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 3,695 reads

Stairway to AlwaysOn Level 4: Analyse & Deploy a Windows Server Failover Cluster

In level 4 of the stairway to AlwaysOn we look at creating a Windows Server Failover Cluster.  Read more...
By Perry Whittle 2014/12/10 | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 4,097 reads

Stairway to AlwaysOn Level 3: Infrastructure 101

In this next level of the Stairway to AlwaysOn, we will look at the components required to implement a Windows Server Failover Cluster.  Read more...
By Perry Whittle 2014/10/29 | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 5,661 reads

Stairway to AlwaysOn Level 2: Storage 101

level 2 of the stairway  Read more...
By Perry Whittle 2014/10/01 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 6,271 reads

Stairway to AlwaysOn Level 1: What is "SQL Server AlwaysOn"?

Level 1 of the stairway looks at exactly what the technologies "AlwaysOn", "Failover Cluster Instance" (FCI) and "Windows Server Failover Cluster" are. We'll look at each in detail and summarize where in the High Availability stack they sit.  Read more...
By Perry Whittle 2016/02/24 (first published: 2014/09/24) | Source: SQLServerCentral.com | Category: failover clustered instance (fci)
Rating: |  Discuss |   Briefcase | 17,003 reads

SQL Server AlwaysOn Availability Groups Fail the Initial Failover Test

The first test of AlwaysOn in SQL Server 2012 is successful, but after testing to swing back again to your primary replica, you find out that automatic failover works only the first time. How come? Carla Abanes explains.  Read more...
By Additional Articles 2014/08/28 | Source: MSSQLTips.com | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 7,569 reads

What you need for a Multi Subnet Configuration for AlwaysOn in SQL Server 2012

You have a new project that requires a primary database server in one building and secondary database server in another building to be configured as a Failover Cluster. What are the important points to consider for this scenario?  Read more...
By Additional Articles 2014/06/25 | Source: MSSQLTips.com | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 2,601 reads

SQL Server 2012 AlwaysOn Groups and FCIs Part 4

This is Part 4 of a series on AlwaysOn and FCI integration in SQL Server. In this article we will learn how to add the iSCSI disk storage to our SQL Server nodes and build the cluster.  Read more...
By Perry Whittle 2014/05/20 | Source: SQLServerCentral.com | Category: mirroring
Rating: |  Discuss |   Briefcase | 3,640 reads

Why Every SQL Server Installation Should Be a Cluster

In this article, I’ll attempt to “convince” you that every SQL Server you put into production should be a SQL Server Failover Cluster Instance (FCI).  Read more...
By Francis Apel 2016/03/25 (first published: 2014/04/15) | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 12,924 reads
   Items 1 to 20 of 41    Older >>