Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag AlwaysOn Rss

   Items 1 to 20 of 44    Older >>
 

Learning AlwaysOn

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 | 1,791 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,092 reads

Synchronizing Read / Write SQL Agent Jobs Across AlwaysOn Replicas

Intro AlwaysOn availability groups are a powerful enhancement to SQLServer HA, and offer many improvements over older database synchronization techniques like...  Read more...
By Jared Zagelbaum 2015/05/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 5,340 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 | 3,550 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 | 2,946 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 | 3,006 reads

AlwaysOn Availability Group Read Only Routing Script

Generate read only routing commands  Read more...
By Jeff Reinhard 2014/11/04 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 851 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 | 4,452 reads

AAG DB State Monitoring

This script is to help monitor the AAG DB synchronization status. It sends an HTML formatted email if Synchronization status is not "Synchronized" or "Synchronizing"  Read more...
By Tom Mongold 2014/10/14 | Source: SQLServerCentral.com | Category: aag
Rating: |  Discuss |   Briefcase | 711 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 | 4,926 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...
Rating: |  Discuss |   Briefcase | 13,169 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,102 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,144 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,450 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 2014/04/15 | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 9,966 reads

SQL Server 2012 AlwaysOn Groups and FCIs

Learn how to set up a SQL Server 2012 AlwaysOn Availability Group and the Failover Clustered Instance (FCI) needed.  Read more...

SQL Server 2012 AlwaysOn Groups and FCIs Part 3

Part 3 of the AO and FCI integration series. This article gets SQL Server configured on the nodes and ready for work.  Read more...
By Perry Whittle 2014/04/03 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 3,314 reads

AlwaysOn Availability Groups - What Not to do when Adding Databases

SQL Server's AlwaysOn Availability Groups provide a very resilient way of providing High-availability for SQL Server databases, but there are inevitable limits to their capacity. Warwick Rudd explains some of the dos and don'ts when adding databases.  Read more...
By 2014/03/28 | Source: SimpleTalk | Category: alwayson
Rating:  Rate this |   Briefcase | 5,185 reads

Adding SQL Server AlwaysOn to existing Failover Clusters

We have a SQL Failover Cluster Instance in our primary data center, and want to implement a second two node Failover Cluster Instance in our secondary data center. A new two node cluster located in our secondary data center was setup, but I could not create a new High Availability Group between the two failover cluster instances. What went wrong?  Read more...
By Additional Articles 2014/03/07 | Source: MSSQLTips.com | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 2,278 reads

SQL Server 2012 AlwaysOn Groups and FCIs Part 2

This is Part 2 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/03/06 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 4,228 reads
   Items 1 to 20 of 44    Older >>
 
Tags
high availability (ha) (18)    
failover clustered instance (fci) (11)    
sql server 2012 (11)    
cluster (10)    
wsfc (7)    
clustering (6)    
availability groups (5)    
blogs (5)    
disaster recovery (dr) (3)    
mirroring (3)    
stairway series (2)    
aag (1)    
administration (1)    
availability group (1)    
backup / recovery (1)    
database mirroring (1)    
editorial (1)    
fail over (1)    
failover (1)    
high availability (1)    
read only routing (1)    
replica (1)    
replication (1)    
service broker (1)    
stairway (1)    
t-sql (1)    
waits and queues (1)