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

Content with tags SQL Server 2012, AlwaysOn Rss

   Items 1 to 11 of 11   
 

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,427 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,096 reads

High availability

By Stanley Kapfunde 2012/05/04 | Category: high availability (ha)
Rating: (not yet rated) |  Discuss |   Briefcase | 2,655 reads

Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

This white paper discusses how to reduce planned and unplanned downtime, maximize application availability, and provide data protection using SQL Server 2012 AlwaysOn high availability and disaster recovery solutions.  Read more...
By Additional Articles 2012/04/27 | Source: Microsoft MSDN | Category: high availability (ha)
Rating:  Rate this |   Briefcase | 3,080 reads

AlwaysOn Secondaries

By Steve Jones 2012/03/29 | Category: high availability (ha)
Rating: (not yet rated) |  Discuss |   Briefcase | 2,144 reads

Managing and Connecting to AlwaysOn Availability Groups

From the previous AlwaysOn Availability Group article, we provided a name for the availability group listener which is simply a unique DNS name as a Virtual Network Name (VNN) to direct read-write requests to the primary replica and read-only requests to the read-only secondary replica.   Read more...
By Additional Articles 2012/03/22 | Source: SQL Server Performance | Category: alwayson
Rating:  Rate this |   Briefcase | 1,539 reads

Using The AlwaysOn Feature of SQL Server 2012

This is the first in a four-part series on the new AlwaysOn feature in SQL Server 2012. In this article, AlwaysOn is introduced and contrasted with previous high-availability solutions in SQL Server. The second part of the series will commence with a detailed walkthrough on preparing the environment for AlwaysOn  Read more...
By Additional Articles 2012/03/15 | Source: SQL Server Performance | Category: sql server 2012
Rating:  Rate this |   Briefcase | 3,514 reads

SQL Server 2012 AlwaysOn & A Thorough Setup

It’s surprisingly easy to set up the new AlwaysOn features. I’ve done it on VMs running on my laptop, from...  Read more...
By Grant Fritchey 2012/03/14 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,841 reads

High Availability Upgrades

Today Steve Jones has a poll about the new AlwaysOn feature in SQL Server 2012. Is it worth the upgrade for your company?  Read more...
By Steve Jones 2012/03/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 225 reads

SQL Server AlwaysOn - Part 2 - Availability Groups Setup

SQL Server has produced some excellent High Availability options, but I was looking for an option that would allow me to access my secondary database without it being read-only or in restoring mode. I need the ability to see transactions occur and query the secondary database.  Read more...
By Additional Articles 2011/11/23 | Source: MSSQLTips.com | Category: sql server 2012
Rating: (not yet rated)  Rate this |   Briefcase | 1,779 reads

New SQL Server AlwaysOn Feature - Part 1 configuration

SQL Server has produced some excellent High Availability options, but I was looking for an option that would allow me to access my secondary database without it being read-only or in restoring mode. I need the ability to see transactions occur and query the secondary database.  Read more...
By Additional Articles 2011/11/21 | Source: MSSQLTips.com | Category: sql server 2012
Rating: (not yet rated)  Rate this |   Briefcase | 2,451 reads
   Items 1 to 11 of 11   
 
Tags
high availability (ha) (9)    
availability groups (2)    
disaster recovery (dr) (2)    
blogs (1)    
clustering (1)    
editorial (1)