 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Clustering / July 20062 running sql to join in a cluster
Hi, I currently have 2 separate SQL Servers under the same domain, running different databases each and having different hardware. We are getting an SAN to centralize the data. If i move the data of both SQL Servers to the SAN then can i configure both sql's to be as one cluster? Are there any articles or so on this procedure please? You would have to create a cluster and then either detach the DB's and reattach them, or take backups of the DB's and restore them onto the new cluster.  SignatureTom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Toronto, ON Canada Hi, I currently have 2 separate SQL Servers under the same domain, running different databases each and having different hardware. We are getting an SAN to centralize the data. If i move the data of both SQL Servers to the SAN then can i configure both sql's to be as one cluster? Are there any articles or so on this procedure please? Thanks Tom for your quick reply. Therefore a cluster (if i am not mistaken) can be of different hardware right? i.e. there is no need that physically they are identical hardware right? > You would have to create a cluster and then either detach the DB's and > reattach them, or take backups of the DB's and restore them onto the new [quoted text clipped - 10 lines] > > Are there any articles or so on this procedure please? Hi Have a look at http://support.microsoft.com/kb/327518/ on the support policy for hardware. Regards SignatureMike This posting is provided "AS IS" with no warranties, and confers no rights. > Thanks Tom for your quick reply. > [quoted text clipped - 16 lines] >> >> Are there any articles or so on this procedure please? Actually, dissimilar nodes are not supported. Indeed, you can't cluster just anything - even if they are identical. They must be in the Windows Catalog *for clustering*. http://www.microsoft.com/windows/catalog/server/default.aspx?subID=22&xslt=globa lsearch&qu=cluster&scope=1 SignatureTom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Toronto, ON Canada Thanks Tom for your quick reply. Therefore a cluster (if i am not mistaken) can be of different hardware right? i.e. there is no need that physically they are identical hardware right? > You would have to create a cluster and then either detach the DB's and > reattach them, or take backups of the DB's and restore them onto the new [quoted text clipped - 10 lines] > > Are there any articles or so on this procedure please? And they must be purchased as a certified cluster solution. Hardware sometimes requires different configuration settings when used in a cluster vs. when used in a stand-alone configuration. SignatureGeoff N. Hiten Senior Database Administrator Microsoft SQL Server MVP > Actually, dissimilar nodes are not supported. Indeed, you can't cluster > just anything - even if they are identical. They must be in the Windows [quoted text clipped - 22 lines] >> >> Are there any articles or so on this procedure please? > Actually, dissimilar nodes are not supported. Indeed, you can't cluster > just anything - even if they are identical. They must be in the Windows > Catalog *for clustering*. Not true. You can cluster dissimilar systems. You can cluster hardware that is not listed in the Windows Catalog. However, there are support issues and already expressed by Michael. I strongly recommend that you purchase clustering solutions only from the Windows Catalog. The question really is one of whether you should do something, and if you think about the entire purpose of high availability, it should be apparent that you want to do it the right way and the right way only. SignatureRuss Kaufmann MVP - Windows Server - Clustering ClusterHelp.com, a Microsoft Certified Gold Partner Web http://www.clusterhelp.com Blog http://msmvps.com/clusterhelp That's what I meant. A client forced me to put together a cluster with unsupported hardware. Then we went into production. Then, it went BOOM. That's probably the biggest "I told you so" in my career. SignatureTom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Toronto, ON Canada . > Actually, dissimilar nodes are not supported. Indeed, you can't cluster > just anything - even if they are identical. They must be in the Windows > Catalog *for clustering*. Not true. You can cluster dissimilar systems. You can cluster hardware that is not listed in the Windows Catalog. However, there are support issues and already expressed by Michael. I strongly recommend that you purchase clustering solutions only from the Windows Catalog. The question really is one of whether you should do something, and if you think about the entire purpose of high availability, it should be apparent that you want to do it the right way and the right way only. SignatureRuss Kaufmann MVP - Windows Server - Clustering ClusterHelp.com, a Microsoft Certified Gold Partner Web http://www.clusterhelp.com Blog http://msmvps.com/clusterhelp |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.