SQL Server Clustering

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 […]

How do I change the IP addresses of clustered SQL Servers?

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 […]

What are the implications of server clustering on replication?

Replications works with SQL Server 7.0, SQL Server 2000, and SQL Server 2005 clustering. But as you might well imagine, configuring and maintaining a SQL Server cluster that is also involved in replication can be a headache. Whether or not you decide to cluster SQL Servers involved in replication has to do with how important the […]

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 […]

How do you restore the master database on a SQL Server cluster?

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 […]

Is clustering, log shipping, or replication the best option for high SQL Server availability?

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 […]

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.  AnswerNo, this is not possible. Microsoft clustering technology uses […]

How can I create a cluster out of two independent SQL Server boxes?

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 […]

How do I deal with a SQL Server cluster that is not acting properly?

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 […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |