SQL Clone
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 6 of 6   
 

Network Configuration of SQL Server Always On Availability Groups in Azure

Implementing SQL Server Failover Clustering in Azure virtual machines differs in several aspects from its on-premises implementations. These differences reflect some of the unique characteristics of the storage and network infrastructure services in the Microsoft cloud environment. In this article, Marcin Policht looks at the networking aspects of clustered deployments of SQL Server 2016 in Azure.  Read more...
By Additional Articles 2017/10/11 | Source: Database Journal | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 1,230 reads

The Connection to the Primary Replica is not Active

In this article, I’m going to talk an issue that I found when joining replica or database on secondary replica to availability group.  Read more...
By Ganapathi varma Chekuri 2017/04/17 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 212 reads

Step by Step Configuring a Dedicated Network for Availability Group

In this article, I will show a procedure to isolate the replication traffic from the public network.   Read more...
By Ganapathi varma Chekuri 2017/04/10 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 604 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,105 reads

Office Hours Webcast 2017/02/01

In this edition of Office Hours, Brent, Erik, and Richie discuss AlwaysOn Availability Groups, execution plans, speeding up log shipping, applying wrong service packs, their favourite high availability solutions, and more.  Read more...
By Additional Articles 2017/02/14 | Source: Brent Ozar Unlimited Blog | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 3,349 reads

Configure SQL Server AlwaysOn Availability Group on a Multi-Subnet Cluster

A “multi-subnet” environment is defined when the OS cluster used as the backbone for AlwaysOn has server nodes that are located in multiple/different subnets. Deploying SQL Server AlwaysOn Availability Groups requires a Windows Server Failover Clustering (WSFC) cluster and each availability replica of a given availability group must reside on a different node of the same WSFC cluster. This post from Manvendra Singh will help you in configuring an HA and DR solution for SQL Server AlwaysOn in multi-subnet networks.  Read more...
By Additional Articles 2017/01/13 | Source: MSSQLTips.com | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 2,897 reads
   Items 1 to 6 of 6