SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Clustering Rss

Search for any content tagged clustering

   Items 1 to 20 of 61    Older >>
 

Workplace Encounters: Using Volume Mount Points in SQL FCIs

How we overcame the A to Z Windows Drive-Letter limitation using Volume Mount Points  Read more...
By Kenneth Igiri 2017/06/26 | Source: SQLServerCentral.com | Category: disks
Rating: |  Discuss |   Briefcase | 485 reads

The Connection to the Primary Replica is not Active

In this article, I’m going to talk an issue that I found when joining replica or database on secondary replica to availability group.  Read more...
By Ganapathi varma Chekuri 2017/04/17 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 176 reads

Step by Step Configuring AlwaysOn with Log Shipping

In this article, I will show you a procedure to combine SQL Server AlwaysOn with logshipping and to make log-shipping to work even in case of failovers between availability replicas in primary site.  Read more...
By Ganapathi varma Chekuri 2017/04/03 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 1,062 reads

Using SQL Server and R Services for analyzing DBA Tasks

Article shows how R Services can help database administrators with their daily work   Read more...
By Tomaž Kaštrun 2017/02/07 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 1,315 reads

Preferred Node Policy-Setting on Traditional SQL Cluster

Preferred node setting facilitates instances on traditional cluster to be on the correct nodes which will lead to load-balancing of the resources.  Read more...
By SQL ADMIN 79 2017/02/02 | Source: SQLServerCentral.com | Category: clustering
Rating: (not yet rated) |  Discuss |   Briefcase | 539 reads

Five Useful SQL Server Management Practices

This article outlines five SQL Server capabilities you can use to enhance your efficiency as a DBA.  Read more...
By Kenneth Igiri 2017/01/18 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,972 reads

Change the Collation Setting for Clustered SQL Server 2014 Instance

In this post I will show a procedure to change collation settings of SQL Server 2014 cluster instance.   Read more...
By Ganapathi varma Chekuri 2016/11/24 | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 448 reads

SQL Server Restart or Cluster Failover Notification

How to create an automatic SQL restart or failover notification.  Read more...
By Lori Brown 2015/12/10 | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 3,392 reads

Add Dependencies to a SQL Server Resource in Windows 2003

In this article, see how to add a dependency to a SQL Server Resource in a Windows 2003 cluster.   Read more...
By Ganapathi varma Chekuri 2015/11/10 | Source: SQLServerCentral.com | Category: windows 2003
Rating: |  Discuss |   Briefcase | 428 reads

How to Add a Drive as a Clustered Physical Disk Resource in Windows

This article is covers how to add a drive as a Clustered Physical Disk Resource in Windows 2003.  Read more...
By Ganapathi varma Chekuri 2015/11/09 | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 1,893 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: always on
Rating: (not yet rated)  Rate this |   Briefcase | 3,236 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: always on
Rating: |  Discuss |   Briefcase | 7,737 reads

Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2

Learn how to create a Windows\SQL Server 2008 virtual cluster. In this article learn about the Windows clustering setup.  Read more...
By Perry Whittle 2013/12/24 (first published: 2011/07/12) | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 9,178 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 | 18,384 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: always on
Rating:  Rate this |   Briefcase | 4,964 reads

Managing MaxMemory Values on an Active-Active Two Node Cluster

How to manage your MaxMemory values on an Active-Active two node cluster.  Read more...
By Michael Lacy 2013/10/24 | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 3,710 reads

Error during installation of an SQL server Failover Cluster Instance

A common issue I've run into while helping with SQL Server Failover Cluster (FCI) installations is the failure of the Network Name. In the following post I'll discuss a bit of background, the common root cause, and how to resolve it.   Read more...
By Additional Articles 2013/10/16 | Source: Microsoft MSDN | Category: clustering
Rating:  Rate this |   Briefcase | 2,134 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 | 18,384 reads

Monitor SQL Instance Balance across Windows Cluster Nodes Using PowerShell

This tip will demonstrate how to monitor SQL Failover Cluster Instances if they become unbalanced using Windows PowerShell.  Read more...
By Additional Articles 2013/05/03 | Source: MSSQLTips.com | Category: clustering
Rating: (not yet rated)  Rate this |   Briefcase | 2,321 reads

Combining AlwaysOn Groups With Failover Cluster Instances

This article discusses failover cluster instances and AlwaysOn groups  Read more...
Rating: |  Discuss |   Briefcase | 9,043 reads
   Items 1 to 20 of 61    Older >>