SQL Server with Mr. Denny:

Clustering


January 7, 2014  8:46 AM

SQL 2012 Cluster, Windows 2012 R2 OS, Windows 2008 R2 Domains



Posted by: Denny Cherry
Allan Hirt, AlwaysOn, Clustering, Database, Database Administration, DataCenter, Error 1069, Error 1194, High Availability, Microsoft Cluster Service, Microsoft Windows, MSCS, SQL Server, SQL Server 2012, SQL Server 2014, Windows 2008 R2, Windows 2012 R2

Recently I was installing SQL Server 2012 on a new Windows 2012 R2 cluster for a client and ran across a bit of a problem. When the SQL Installer was attempting to start SQL Server for the first time SQL Server was throwing Windows errors 1069 and 1194 which basically say...

Cluster...

December 11, 2013  2:00 PM

Clustering in Amazon EC2 – Tomorrow!



Posted by: Denny Cherry
Clustering, Database, Database Administration, DataCenter, High Availability, Microsoft Cluster Service, Microsoft Windows, MSCS, Recovery, Server Hardware, SIOS Technologies, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014

Tomorrow (December 12th) at noon Pacific Time I'm presenting a session with SIOS Technologies on using their SANLess Clustering Technology to build a clustered SQL Server for High Availability within Amazon's EC2 cloud. This session is...


August 27, 2013  6:46 PM

SQL Connections Post-Con Coming Next Month



Posted by: Denny Cherry
AlwaysOn, Availability Groups, Clustering, Database, Database Administration, Dev Connections, High Availability, Microsoft Cluster Service, MSCS, Server Hardware, SQL Server

That's right, next month I'm giving a post con at the SQL/Dev Connections conference.  The post con is titled


November 7, 2012  2:00 PM

Passive AlwaysOn Replicas, not as free as you might think



Posted by: Denny Cherry
AlwaysOn, Availability Groups, Clustering, Database, Microsoft Cluster Service, MSCS, SQL Licensing, SQL Server, SQL Server 2012

With the release of SQL Server 2012 and specifically the AlwaysOn feature we need...


September 12, 2012  2:00 PM

When clustering guests, host them on different LUNs



Posted by: Denny Cherry
Clustering, Hyper-V, SQL Server, Storage, VMware

When building virtual clusters under any HyperVisor you need to make sure that all the nodes of the cluster are being hosted on different LUNs on the hosts. If you build the VMs on the same LUN and that LUN fails for some reason then both of the nodes of the cluster will be down, and the whole...


November 28, 2011  2:00 PM

Using CNAMEs with clustered file share resources



Posted by: Denny Cherry
Clustering

One of the questions that I see on the forums every once in a while is how to get a CNAME working with a network share.  For example if you have a cluster where the server names are "SERVER1 and SERVER2" and the virtual name is "VIRT1" how can I allow users to connect to the network shares by...


September 19, 2011  7:13 PM

Slide Decks for #sqlsat95



Posted by: Denny Cherry
Clustering, Indexing, SQL Saturday, SQL Saturday 95, SQL Server

This last weekend was SQL Saturday 95, and it was a great event.  I was speaking during 5 sessions.  Three were my own sessions, and two were panels (one panel I did solo as my co-presenter got sick and couldn't make it).  For my three sessions you'll find my slide decks below.


August 18, 2011  4:30 PM

When working with SQL in a cluster, the account rights on both nodes of the cluster need to be the same



Posted by: Denny Cherry
Clustering, Database, Permissions, Security, SQL Server

Recently I was working with a clients SQL Server cluster.  The managed service provide had installed some Windows patches causing the SQL Cluster to fail over to the other node.  No big deal, everything appeared to be working as normal.

After a couple of days we noticed...


January 4, 2010  11:00 AM

When setting up a new Windows Cluster test failover before releasing to production



Posted by: Denny Cherry
Clustering, Microsoft Cluster Service

When you build a new Microsoft Cluster Server cluster always be sure to fail over all the drives between all the nodes before installing SQL Server on it and deploying the cluster to production.  The first time that you fail over a cluster from one node to another the disks can take a very long...


December 28, 2009  11:00 AM

How to convert a standalone instance to a clustered instance



Posted by: Denny Cherry
Clustering, SQL

This question has come up a couple of times on various forums on the Inter-webs so I figured I'd write up something a little more in-depth than I'd be able to do on a forum. There's no way to easily flip a standalone SQL Server instance to a clustered instance.  However moving a standalone...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: