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

Content with tag AlwaysOn Rss

   Items 1 to 20 of 47    Older >>
 

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 | 1,676 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,104 reads

AlwaysOn Replica Failover Status Check

Template script/stored proc for sending notification and performing post failover tasks  Read more...
By Stan Lin 2015/11/27 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 748 reads

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 | 2,468 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,661 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,644 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,277 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,386 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,620 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 | 962 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,144 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 | 752 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 | 5,675 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 | 14,928 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,331 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,397 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,591 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 | 10,018 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,426 reads
   Items 1 to 20 of 47    Older >>
 
Tags
high availability (ha) (18)    
failover clustered instance (fci) (11)    
sql server 2012 (11)    
cluster (10)    
availability groups (7)    
wsfc (7)    
clustering (6)    
blogs (5)    
disaster recovery (dr) (3)    
mirroring (3)    
failover (2)    
replica (2)    
stairway series (2)    
aag (1)    
administration (1)    
applicationintent (1)    
availability group (1)    
backup and restore (1)    
database mirroring (1)    
editorial (1)    
fail over (1)    
high availability (1)    
read only routing (1)    
read-only (1)    
replication (1)    
routing (1)    
security (1)    
service broker (1)    
stairway (1)    
transparent data encryption (tde) (1)    
t-sql (1)    
waits and queues (1)