SQL Server Clustering

We have five SQL Servers and want to not only upgrade, but to cluster these servers as well.

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

How do I restore a Master Database in a SQL Server 7.0 or 2000 clustering environment?

This is especially important in a disaster scenario where the Master database is corrupt and you need to restore from a previous backup of the Master database. To restore a Master database, the server has to be started in the single user mode, and that’s where the problem comes in, since Cluster Administrator is the only place […]