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

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,084 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 | 4,542 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,751 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 | 2,944 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 | 4,723 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,511 reads

AlwaysOn and Database Mirroring

By Steve Jones 2013/12/13 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,556 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: (not yet rated)  Rate this |   Briefcase | 3,779 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,372 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,243 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,680 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,046 reads

Combining AlwaysOn Groups With Failover Cluster Instances

This article discusses failover cluster instances and AlwaysOn groups  Read more...
By Perry Whittle 2012/09/04 | Source: SQLServerCentral.com | Category: fci
Rating: |  Discuss |   Briefcase | 5,562 reads

AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups

SQL Server 2012 AlwaysOn Availability Groups provides a unified high availability and disaster recovery (HADR) solution that improves upon legacy functionality previously found across disparate features. Prior to SQL Server 2012, several customers used database mirroring to provide local high availability within a data center, and log shipping for disaster recovery across a remote data center. With SQL Server 2012, this common design pattern can be replaced with an architecture that uses availability groups for both high availability and disaster recovery. This paper details the key topology requirements of this specific design pattern, including quorum configuration considerations, steps required to build the environment, and a workflow that shows how to handle a disaster recovery event in the new topology.  Read more...
By Additional Articles 2012/08/31 | Source: Microsoft MSDN | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 1,837 reads

AlwaysOn Availability Groups in SQL Server 2012

This article discusses and demonstrates AlwaysOn Availability groups in SQL Server 2012, a new feature for high availability.  Read more...
By Perry Whittle 2012/08/28 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 6,028 reads

SQL Server 2012 AlwaysOn Availability Groups – Part 3: Setting up AlwaysOn through T-SQL

In the last blog posting about AlwaysOn you have seen how you can deploy your first Availability Group through the AlwaysOn...  Read more...
By 2012/07/25 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,430 reads

SQL Server 2012 AlwaysOn Availability Groups – Part 2

It's already a long time since I have blogged how to configure your Windows- and SQL Servers for SQL Server 2012...  Read more...
By 2012/07/23 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,484 reads

A first look at SQL Server 2012 Availability Group Wait Statistics

If you are trouble-shooting an AlwaysOn Availability Group topology, a study of the wait statistics will give a pointer to many of the causes of problems. Although several wait types are documented, there is nothing like practical experiment to familiarize yourself with new wait stats, and Joe Sack demonstrates a way of testing the sort of waits generated by an availability group under various circumstances.  Read more...
By Additional Articles 2012/06/12 | Source: SimpleTalk | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 1,830 reads

High availability

By Stanley Kapfunde 2012/05/04 | Category: high availability (ha)
Rating: (not yet rated) |  Discuss |   Briefcase | 2,635 reads
   Items 1 to 20 of 29    Older >>
 
Tags
high availability (ha) (18)    
sql server 2012 (11)    
availability groups (5)    
blogs (4)    
clustering (3)    
disaster recovery (dr) (3)    
failover cluster (3)    
cluster (2)    
fci (2)    
mirroring (2)    
administration (1)    
backup / recovery (1)    
database mirroring (1)    
editorial (1)    
fail over (1)    
failover clustered instance (fci) (1)    
replica (1)    
replication (1)    
service broker (1)    
t-sql (1)    
waits and queues (1)    
wsfc (1)