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

Articles with tag High Availability (HA) Rss

Search for any content tagged high availability (ha)

<< Newer    Items 21 to 40 of 74    Older >>
 

Migration Guide: Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments

This paper provides guidance for customers who prior to SQL Server 2012 have deployed SQL Failover Clustering for local high availability and database mirroring for disaster recovery, and who want to migrate to SQL Server AlwaysOn. It describes the corresponding SQL Server AlwaysOn scenario and the migration paths to SQL Server AlwaysOn. It also contains the important knowledge and considerations that you must know in order to successfully migrate to a HADR solution based on SQL Server AlwaysOn technology, which implements AlwaysOn Failover Cluster Instances for high availability and AlwaysOn Availability Groups for disaster recovery.   Read more...
By Additional Articles 2012/04/13 | Source: Microsoft MSDN | Category: clustering
Rating: (not yet rated)  Rate this |   Briefcase | 2,233 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,545 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,518 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 | 226 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,789 reads

How to Setup Log Shipping for Multiple Databases

This article by Brian Davey describes how to setup log shipping for a large number of databases minimizing the number of jobs needed thus significantly reducing CPU and memory usage.  Read more...
By Brian Davey 2011/09/28 | Source: SQLServerCentral.com | Category: log shipping
Rating: |  Discuss |   Briefcase | 4,908 reads

SQL Server Replication: Providing High Availability using Database Mirroring

This white paper describes how to use database mirroring to increase the availability of the replication stream in a transactional environment. The document covers setting up replication in a mirrored environment, the effect of mirroring partnership state changes, and the effect of mirroring failovers on replication. In addition, it describes how to use LSN-based initialization to recover from the failover of a mirrored Subscriber database.  Read more...
By Additional Articles 2011/05/17 | Source: SQLCAT | Category: replication
Rating: (not yet rated)  Rate this |   Briefcase | 3,278 reads

Database Mirroring Setup

This great tutorial shows how to set up database mirroring across two instances in a virtual environment.  Read more...
By Brady Upton 2014/01/31 (first published: 2011/04/12) | Source: SQLServerCentral.com | Category: database mirroring
Rating: |  Discuss |   Briefcase | 13,203 reads

Using Disparate File Paths in SQL Server Database Mirroring

Learn how you can setup Database Mirroring using disparate file paths and drive letters.  Read more...
By Perry Whittle 2011/03/01 | Source: SQLServerCentral.com | Category: database mirroring
Rating: |  Discuss |   Briefcase | 6,260 reads

What's a Passive Server?

Today Steve Jones talks about licensing and the complexity if brings in various scenarios. Do your passive servers have to be licensed? What is the definition of "passive"?  Read more...
By Steve Jones 2011/02/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 204 reads

7 Things that High Availability is Not

Wesley has heard High Availablity touted as all sorts of technological cure-all for busy SysAdmins and DBAs, and now he's taking a stand against it. There are a range of things that High Availability is regularly confused with (either deliberately or innocently), and Wesley's clearing it all up  Read more...
By Additional Articles 2011/02/01 | Source: SimpleTalk | Category: high availability (ha)
Rating: (not yet rated)  Rate this |   Briefcase | 4,491 reads

Creating A SQL Server 2008\2008 R2 Failover Cluster

Details how to install a SQL Server 2008\2008R2 Failover Cluster Instance  Read more...
By Perry Whittle 2013/12/23 (first published: 2011/01/19) | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 17,934 reads

Uninstalling a SQL Server Clustered Instance

I have installed and uninstalled several instances of SQL Server in the past. Today, I need to uninstall a SQL Server 2008 R2 clustered instance. I have never uninstalled a clustered instance of SQL Server before. Can you provide a how-to guide to uninstall a clustered instance of SQL Server 2008 R2?  Read more...
By Additional Articles 2010/12/06 | Source: MSSQLTips.com | Category: clustering
Rating: (not yet rated)  Rate this |   Briefcase | 2,752 reads

Convert Mirroring to Log Shipping

Describes how to convert database mirroring to log shipping in SQL 2005/2008.  Read more...
By Jeremy Egbert 2010/08/19 | Source: SQLServerCentral.com | Category: database mirroring
Rating: |  Discuss |   Briefcase | 5,507 reads

How to Evict a Failed Node and Add it Back to SQL Server 2005 Cluster

Adding and removing nodes in SQL Server Clusters is not so difficult, and instructions on how to do so abound on the internet. However, mismanagement when adding/removing nodes can quickly become a 'gotcha' that wastes time. Bo Chen offers insight into some of those scenarios that are not normally covered in the standard online documents.   Read more...
By Additional Articles 2010/04/26 | Source: Database Journal | Category: clustering
Rating:  Rate this |   Briefcase | 1,811 reads

The Log Shipping Standard

Log shipping is a tool that has more benefits than just recovering from a major disaster. Steve Jones thinks this might be a tool that DBAs should use for all their critical databases.  Read more...
By Steve Jones 2010/04/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 607 reads

Multiple Mirrors

Should we evolve the database mirroring technology to work with multiple mirrors? Steve Jones says this might be an interesting idea.  Read more...
By Steve Jones 2010/02/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 294 reads

Pre Check List for 64 BIT SQL Server 2008 Cluster Installation

My tips for cluster installation with Windows 2008 and SQL 2008 on a 64 BIT server which is clustered.  Read more...
By Rudy Panigas 2009/12/31 | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 7,033 reads

Understanding why there is still downtime with Microsoft Clustering

I want to institute a high availability solution for SQL Server with no downtime. I am planning on using Microsoft clustering, but I have been told that in the event that the cluster moves the SQL Server from one physical server to another, that there is some downtime. Why is this so?  Read more...
By Additional Articles 2009/11/24 | Source: MSSQLTips.com | Category: clustering
Rating:  Rate this |   Briefcase | 3,887 reads

SQL Server 2008 Failover Clustering

This white paper complements the existing documentation on planning, implementation, and administration of a SQL Server 2008 failover cluster, which can be found in Microsoft SQL Server 2008 Books Online. There are links to relevant existing content throughout the paper, which is intended primarily for a technical audience. This white paper covers failover cluster architecture and concepts for Windows Server (2003 and 2008) and SQL Server 2008; installation of a SQL Server 2008 failover cluster; upgrades and updates to SQL Server 2008 failover clustering; and maintenance and administration of SQL Server 2008.  Read more...
By Additional Articles 2009/10/02 | Source: SQLCAT | Category: clustering
Rating: (not yet rated)  Rate this |   Briefcase | 3,398 reads
<< Newer    Items 21 to 40 of 74    Older >>