SQL Server Clustering
I am trying to backup my databases from my clustered shared array to a local disk, but I can’t see the local disk when I run the Backup Wizard. Why?
This is a problem with both SQL Server 7.0 and SQL Server 2000 clustering. I don’t know if this is a bug, or there was some intentional reason for doing this. But there is at least one work-around that I am familiar with. The work-around is to create a backup device on the local disk […]
Is it advisable to run both Terminal Services (application mode) and SQL Server on the same cluster together?
Technically speaking, what you want to do is possible, but I wouldn’t recommend it. One problem is that Terminal Services (Application Mode) has some limitations under clustering, and is not fully cluster aware. But the biggest problem you will run into is performance. Terminal Services (Application Mode) is a huge resource hog. The same is […]
I have a question on how to uninstall a SQL Server 2000 instance installation from a Windows 2000 cluster.
Question I have a question on how to uninstall a SQL Server 2000 instance installation from Windows 2000 cluster. I tried to use the setup program on the install CD, but I am not getting the option to uninstall when I run the setup program. Let me give you brief scenario as what has happened: […]
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 […]
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 […]
Is it possible for both nodes in a SQL Server cluster to open up the same .MDF & .LDF file on the shared array simultaneously?
Question Is it possible for both nodes in a SQL Server cluster to open up the same .MDF & .LDF file on the shared array simultaneously and still be able to perform standard SQL calls (SELECT, UPDATE & INSERT) without causing corruption, performance degradation and/or sharing issues. Answer No, this is not possible. Microsoft clustering technology […]
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 […]
Question We 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 […]
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 […]