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