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

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 | 224 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,775 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,849 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,273 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,143 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,237 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,489 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,844 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,709 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,490 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,801 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 | 605 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 | 292 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,023 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,859 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,395 reads

Database Mirroring Using T-SQL

Part three of this series illustrates how to use a T-SQL script to create database mirroring between a principal and mirrored server.  Read more...
By Additional Articles 2009/08/20 | Source: Database Journal | Category: database mirroring
Rating:  Rate this |   Briefcase | 3,177 reads

Database Mirroring in SQL Server 2008

Learn the basics of the Database mirroring in SQL Server 2008. Mak provides a step-by-step on how to create database mirroring. Subsequent installments will discuss how to add data on the principal server and how data is mirrored to the mirrored server.  Read more...
By Additional Articles 2009/07/13 | Source: Database Journal | Category: database mirroring
Rating:  Rate this |   Briefcase | 2,994 reads

Maintaining high availability of SQL Server VMs

Learn to take advantage of Hyper-V and Windows 2008 in order to achieve fault-tolerant and highly available SQL Server virtual machines.  Read more...
By Additional Articles 2009/06/23 | Source: SearchSQLServer | Category: virtualization
Rating:  Rate this |   Briefcase | 2,154 reads
<< Newer    Items 21 to 40 of 71    Older >>