niladri.primalink (4/15/2013)
Hi All,if my windows in clustering mode, is my database in SQL server also in Clustering? or I will have to do it for SQL server.
Actually we have huge database for client. Now we want to cluster for windows and for Database. Now my question is will we have to do 2 different clustering one for windows and one for database...or just clustering for only windows?
Please reply...
-You install MS Clustering services 1st (two node at min. You can actually with one, but makes no sense)
-You install MS-SQL as a failover instance. Then it will run as a cluster aware SQL installation
If you do not require geographical dispersion, MS Clustering should work. Keep in mind that if the same datacenter or SAN fails, or both servers, the whole Cluster goes down.
If you need geographical dispersion, let's say Houston and Dallas, then you may need a software like Veritas. In my experience, most companies do not require it, unless the database is MC and extremely important for the business.
So, two steps... one Windows Cluster..... one SQL failover (at least) after installing the Cluster Service or make it run ... also, you need a SAN (common storage) for your Cluster.
You can start learning more, with a very simple link or resource like this one: Windows Clustering