SQL Server Performance

  • Home
  • Articles
  • Forums
  • Tips
  • Training
  • FAQ's
  • Blogs
  • Software
  • Books
  • About Us
RSS Feeds
Sign in | Join


FAQ Topics

All FAQ's
General DBA
General Developer
DBA Performance Tuning
Developer Performance Tuning
Clustering
Error Messages

USEFUL SITES :

ASP.NET Tutorials
Windows and SQL Azure Tutorials
Cloud Hosting Magazine
SharePoint Tutorials
Windows Server Help

Write for Us

Share your SQL Server knowledge with others and raise your profile in the community More...
Latest Articles

A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server

More     
 
Latest FAQ's

Add Node to A SQL Server failover Cluster failed with invalid ...
SQL Server Destination remote server error
Setting Up Data And Log Files For SQL Server
Will Check Constraints Improve Database Performance?

More     
   
Latest Software Reviews

dbForge Review
Spotlight on ApexSQL Diff - Server-based database comparison tool ...
Spotlight on ApexSQL Data Diff - Server-based database comparison tool ...
Spotlight on ApexSQL Doc 2008

More     

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?


Answer

Although it is a pain, here is what I suggest:

  • The very first step is to backup your databases (system and user) and test your backups to be sure you can restore them.
  • Verify that the hardware you have is on the Microsoft Hardware Compatibility List.
  • Attach the shared disk array to the two servers, and test the setup to see that everything works correctly.
  • Most likely, you don't have a version of the Windows OS that supports clustering , which is necessary for clustering. Because of this, you must rebuild the servers from scratch. By this, I mean to wipe out the previous operating system and then install a version of the Windows OS that supports clustering. You can install the new operating system before or after you install your shared disk array.
  • Once you have Windows properly installed, then install and test the Windows Clustering Service.
  • Now you are ready to install SQL Server clustering, and then test it.
  • Finally, restore your database backups.

If, by chance, you already have a version of the Windows OS that supports clustering installed on these two servers, and if you already a version of SQL Server installed that supports clustering, you still have a lot of work ahead of you, but a little less. Here's what I recommend in this case:

  • Backup your databases and test your backups to be sure you can restore them.
  • Verify that the hardware you have is on the Microsoft Hardware Compatibility List.
  • Attach the shared disk array to the two servers, and test the setup to see that everything works correctly.
  • Uninstall SQL Server from both nodes. Leave the databases files intact so that you can reattach them later, if you like.
  • Install the Windows Clustering Service.
  • Reinstall SQL Server using the clustering option in Setup.
  • Finally, restore your database backups, or if all the MDBs and LDFs are still intact, you can reattach them instead of restoring your backups.







C# Help and Tutorials | PHP MySQL Tutorial | Sharepoint Tutorial | Azure Tutorial | Cloud Hosting Magazine | ASP.NET Tutorials | Windows Server Help | Windows Phone Pro | Silverlight Ace | Visual Studio Tutorials | Home | Peformance Articles | Audit Articles | Business Intelligence Articles | Clustering Articles | Developer Articles | Reporting Services Articles | DBA Articles | ASP.NET / ADO.NET Articles | SQL Server Training Videos | DBA FAQ's | Developer Peformance FAQ's | DBA Peformance FAQ's | Developer FAQ's | Clustering FAQ's | Error Messages | Audit Tool Reviews | Backup Tool Reviews | Coding Tool Reviews | Compare Tool Reviews | Documentation Tool Reviews | Design Tool Reviews | Monitoring Tool Reviews | Log Tool Reviews | Reporting Tool Reviews | Clustering Tool Reviews | Security Tool Reviews | Change Management Tool Reviews | Remote Access Tool Reviews | Book Reviews | Security Tool Reviews | ADO.NET / ASP.NET | Administration | Analysis/OLAP Services | Application Development | Configuration | Components | ETL | Hardware | High Availability | Hints | Index | Misc | Operating Systems | Performance Tuning | Replication | T-SQL | Views


              © 2010 Jude O'Kelly. All rights reserved