Caveats and Recommendations
There was a day when I was very high on clustering SQL Server. If budget allows, I still
think clustering is a technology to be considered as a piece of the entire disaster recovery
puzzle. However, with today??™s hardware, there just isn??™t the same driving need for clustering
as there has been in years past.
As with all technologies, you can follow some general guidelines to keep yourself in
a safe harbor, so to speak. Consider the following guidelines when implementing clustering
in a SQL Server environment:
??? Never consider SQL Server clustering as the primary means of disaster mitigation:
Clustering can play an important role, but its applications are specific to highavailability
issues rather than disaster mitigation.
??? Make sure you understand failover scenarios: Be clear on what actions the cluster
will take in the event of a failover. If you don??™t, you could be in for a surprise.
??? Perform all service maintenance with the cluster utilities: Controlling a service
directly, either from the command line or from the Services Control Panel applet,
could be interpreted as a failure event, causing all services to fail to a standby node.
Pages:
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374