SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag always on Rss

Search for any content tagged always on

   Items 1 to 20 of 49    Older >>
 

Stairway to AlwaysOn Level 4: Analyse and 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 2017/11/08 (first published: 2014/12/10) | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 4,844 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 2017/11/01 (first published: 2014/10/29) | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 6,668 reads

Setup and Implement SQL Server 2016 Always On Distributed Availability Groups

SQL Server 2016 introduced a new feature called Distributed Availability Group. A Distributed Availability Group is a special type of Availability Group that spans two separate Availability Groups. Edwin Sarmiento explains.  Read more...
By Additional Articles 2017/09/08 | Source: MSSQLTips.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 3,496 reads

Stairway to AlwaysOn Level 2: Storage 101

In this new level of the stairway, we examine the storage knowledge you need for an AlwaysOn configuration.  Read more...
By Perry Whittle 2017/08/09 (first published: 2014/10/01) | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 7,297 reads

Step by Step Configuring AlwaysOn with Log Shipping

In this article, I will show you a procedure to combine SQL Server AlwaysOn with logshipping and to make log-shipping to work even in case of failovers between availability replicas in primary site.  Read more...
By Ganapathi varma Chekuri 2017/04/03 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 1,119 reads

Maintenance Routines for AlwaysOn

How to determine what replica(s) to perform maintenance routines  Read more...
By Ginger Keys 2016/12/05 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 1,591 reads

SQL Server 2016 Distributed Availability Groups

High availability solution with cross cluster support using the new Distributed Availability Groups  Read more...
By Jennifer Brocato 2016/11/14 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 1,036 reads

TempDB growth due to version store on AlwaysOn secondary server

On a not-so-busy day, I received an alert saying tempdb has grown to 90 percent of the drive size and there is only 10 percent space left on the drive. The server is a SQL Server 2014 instance and hosts AlwaysOn secondary databases.  Read more...
By Ramya Makam 2016/11/07 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 1,353 reads

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 Chekuri 2016/09/06 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 744 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 | 4,053 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: always on
Rating: (not yet rated)  Rate this |   Briefcase | 2,413 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,994 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: always on
Rating: |  Discuss |   Briefcase | 1,562 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 | 18,108 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: always on
Rating: |  Discuss |   Briefcase | 2,264 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: always on
Rating: |  Discuss |   Briefcase | 2,143 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: always on
Rating: (not yet rated) |  Discuss |   Briefcase | 2,667 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 (ha)
Rating: |  Discuss |   Briefcase | 3,281 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 | 5,178 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,960 reads
   Items 1 to 20 of 49    Older >>