SQL Server Clustering
Question I have recently set up a two-node cluster using Windows 2000. I have a single RAID 5 shared disk array that is sliced into two logical disks which appear in Windows 2000 Disk Manager as Disk 1 and Disk 2. I have also created one primary partition on each disk and have assigned drive […]
Question I was told by a friend, that at his last company they had a SQL Server environment which contained four clustered servers that were load balanced. So in effect, when they pulled the plug on one server, the other three would adjust and pick up the load.From my experience of setting up and using […]
We have a SQL Server 2000 cluster. I have been trying to get SQLMail to work with it, but have failed. What am I doing wrong?
SQLMail is not officially supported under SQL Server7.0 clustering. SQLMail in SQL Server 2000 is supposed to work under clustering, although I have not personally tried it. In fact, I don’t recommend it as you must add mail clients to both servers, and I don’t like the idea of adding mail clients (with all the […]
We are planning a new SQL cluster. We intend to have the two servers separated by 100 meters. Will the cluster’s shared disk array be a single point of failure for us?
A cluster is designed to provide fault tolerance for the physical servers, the operating system, and the application software, but not for data. Fault tolerance for data should be handled by a fault tolerant shared disk array, log shipping, or database mirroring (in SQL Server 2005). So in a sense, the shared disk array is […]
Question Recently, due to corporate requirements, we had to change all the IP numbers on all our servers, including our clustered SQL server. Since this change, we cannot set up an ODBC connection or connect to Enterprise Manager using the virtual IP address or the virtual name of the server, although we can using the […]
Question If I have two SQL Server servers running separately, and want to create a clustered environment with them. Do I need to build the Windows cluster first, and then re-install SQL Server , or can I cluster the database engine post-installation? AnswerAlthough it is a pain, here is what I suggest: The very first […]
QuestionWe are having a problem with our SQL Server cluster. Everything was originally set up and configured properly, then for some reason the SQL Server Fulltext service failed on the primary node, and will not run on this node any longer. I changed the configuration of Fulltext so that this failure would not prevent the […]
Question We currently have five SQL Server servers managing over 100 databases. We would like upgrade to the newest version, and at the same time incorporate clustering. What are our clustering options, and what would you recommend? AnswerIt looks like you have a big project ahead of you. There are several options, so let’s take […]
Question I have learned a lot from your articles on SQL Server clustering. We are moving towards a clustering environment very soon, but there is one problem that I can’t solve before we go live. Restoring a Master database in a clustering environment is a big problem. This is especially important in a disaster scenario […]
Question I am after a some advice for an installation that I am about to start.The company I am currently working for has just invested heavily in a SAN. It is located in two sites with high speed connections. The solution is fully fault tolerant and each server is configure with 2 x 2GB fibre […]