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 38    Older >>
 

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 | 550 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 | 2,757 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 | 606 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 | 3,238 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 2014/09/24 | Source: SQLServerCentral.com | Category: fci
Rating: |  Discuss |   Briefcase | 8,773 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 | 6,884 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 | 1,923 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,097 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,755 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,032 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,026 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 | 1,997 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 | 3,881 reads

SQL Server 2012 AlwaysOn Groups and FCIs Part 1

Learn how to get a Failover Cluster Instance set up and configured with Windows and SQL Server. This is part of a series showing how to combine a Failover Cluster Instance of SQL Server with an AlwaysOn availability group.  Read more...
By Perry Whittle 2014/02/10 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 6,771 reads

An AlwaysOn Bug with Service Broker Transmission Queue

Paul Brewer talks about an AlwaysOn problem affecting the Service Broker Transmission Queue.  Read more...
By Paul Brewer 2014/01/07 | Source: SQLServerCentral.com | Category: service broker
Rating: |  Discuss |   Briefcase | 2,640 reads

AlwaysOn and Database Mirroring

By Steve Jones 2013/12/13 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,629 reads

SQL Server 2012 AlwaysOn High Availability and Disaster Recovery Design Patterns

SQL Server 2012 AlwaysOn provides flexible design choices for selecting an appropriate high availability and disaster recovery solution for your application. This article looks at the common design patterns.  Read more...
By Additional Articles 2013/12/11 | Source: MSDN Communities | Category: alwayson
Rating:  Rate this |   Briefcase | 4,052 reads

Configure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using PowerShell

With SQL Server 2012 AlwaysOn Availability Groups, you can configure read-only routing and to automatically redirect the read-only workloads to a secondary replica after a failover. Can this be done using Windows PowerShell?  Read more...
By Additional Articles 2013/04/17 | Source: MSSQLTips.com | Category: alwayson
Rating:  Rate this |   Briefcase | 1,477 reads

Backing Up SQL Server Databases Participating In Availability Groups

So I am using this new technology called Availability Groups that was introduced in SQL Server 2012. I have heard I can offload my backups to a secondary replica, but I am not sure how that works or how to configure those backups. Are there any limitations? Check out this tip to learn more.  Read more...
By Additional Articles 2013/02/25 | Source: MSSQLTips.com | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 1,345 reads
   Items 1 to 20 of 38    Older >>
 
Tags
high availability (ha) (18)    
sql server 2012 (11)    
cluster (7)    
fci (6)    
availability groups (5)    
blogs (4)    
wsfc (4)    
clustering (3)    
disaster recovery (dr) (3)    
failover cluster (3)    
mirroring (3)    
aag (1)    
administration (1)    
availability group (1)    
backup / recovery (1)    
database mirroring (1)    
editorial (1)    
fail over (1)    
failover (1)    
failover clustered instance (fci) (1)    
read only routing (1)    
replica (1)    
replication (1)    
service broker (1)    
stairway series (1)    
t-sql (1)    
waits and queues (1)