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

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 | 530 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 | 2,619 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 | 7,538 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,846 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,886 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 | 2,948 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,698 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 | 2,982 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,005 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,950 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,822 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,582 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,623 reads

AlwaysOn and Database Mirroring

By Steve Jones 2013/12/13 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,621 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,008 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,461 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,320 reads

Expanding AlwaysOn Availability Groups with Replication Publishers

SQL Server 2012 AlwaysOn Availability Groups provide a high-availability and disaster-recovery solution for you SQL Server 2012 environments. Replication has been around in SQL Server for quite some time and allows you to scale out your environment. Warwick Rudd explains how to join these technologies together.   Read more...
By Additional Articles 2013/02/12 | Source: SimpleTalk | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 1,798 reads

SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance

SQL Server Failover Clustering, which includes support for both local and multisite failover configurations, is part of the SQL Server 2012 AlwaysOn implementation suite, designed to provide high availability and disaster recovery for SQL Server. The multisite failover clustering technology has been enhanced significantly in SQL Server 2012. The multisite failover cluster architecture, enhancements in SQL Server 2012 to the technology, and some best practices to help with deployment of the technology are the primary focus of this paper.  Read more...
By Additional Articles 2012/11/16 | Source: Microsoft MSDN | Category: sql server 2012
Rating: (not yet rated)  Rate this |   Briefcase | 2,122 reads
   Items 1 to 20 of 36    Older >>
 
Tags
high availability (ha) (18)    
sql server 2012 (11)    
cluster (6)    
availability groups (5)    
fci (5)    
blogs (4)    
clustering (3)    
disaster recovery (dr) (3)    
failover cluster (3)    
mirroring (3)    
wsfc (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)