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

Content with tag cluster Rss

   Items 1 to 9 of 9   
 

SQL Server 2012 AlwaysOn Groups and FCIs Part 4

This is Part 4 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/05/20 | Source: SQLServerCentral.com | Category: mirroring
Rating: |  Discuss |   Briefcase | 2,790 reads

Why every SQL Server installation should be a cluster

In this article, I’ll attempt to “convince” you that every SQL Server you put into production should be a SQL Server Failover Cluster Instance (FCI).  Read more...
By Francis Apel 2014/04/15 | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 9,575 reads

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,807 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 | 3,630 reads

Powershell script to interactively move cluster resources

Powershell code to interactively move cluster resources between nodes. Intended for Windows 2012 and SQL 2012.  Read more...
By Rolando Hernandez 2013/11/19 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: (not yet rated) |  Discuss |   Briefcase | 463 reads

Script to determine if two instances are on the same node

Determines if two instances of a Active/Active cluster are running on the same node.  Read more...
By Gregory Ferdinandsen 2013/11/13 | Source: SQLServerCentral.com | Category: wmi
Rating: |  Discuss |   Briefcase | 759 reads

Updating the TCP Port on a SQL Server Cluster Node

When installing 2 SQL Server instances on a Windows Cluster, the installation program requires a Named Instance during the installation of the second node and a dynamic TCP port is created. How do you update the TCP port after the installation in a clustered environment for the named instance?  Read more...
By Additional Articles 2013/05/27 | Source: MSSQLTips.com | Category: tcp
Rating: (not yet rated)  Rate this |   Briefcase | 3,797 reads

Retrieve SQL Instance Connect Info

This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port  Read more...
Rating: |  Discuss |   Briefcase | 1,342 reads

SQL Start up Script

This is a script that I run when SQL starts to notify me via email that a server has restarted as well as the location of the server.  Read more...
By Monte Kottman 2012/09/25 | Source: SQLServerCentral.com | Category: startup
Rating: |  Discuss |   Briefcase | 1,696 reads
   Items 1 to 9 of 9   
 
Tags
alwayson (3)    
mirroring (3)    
node (2)    
powershell (2)    
agent (1)    
always on (1)    
email (1)    
failover (1)    
fci (1)    
interactive (1)    
ports (1)    
resource groups (1)    
scom (1)    
sql server (1)    
sql server 2012 (1)    
startup (1)    
system center operations manager (1)    
tcp (1)    
windows 2012 (1)    
wmi (1)    
wql (1)