October 18, 2017 at 1:37 pm
Hi,
I have a question regarding sql 2012 cluster 2 nodes
OS: Windows 2012 with AD
SQL: MS SQL Server 2012
Cluster: 2 nodes
First time i'm going to install sql 2012 cluster for 2 nodes, like A and B. My question.
Shall i install cluster on both machine in A and B?
Shall i create ms sql database on both machine?
Shall i restore database on both machine ? like A and B
Last, what are they requirement for installation such as Cluster Name, Domain admin, or Administrator on Domain Control admin rights?
Only on MS SQL Server side question.
Network card and Heartbeat, cluster ip, i have already.
Thank you
October 18, 2017 at 1:42 pm
stockholm - Wednesday, October 18, 2017 1:37 PMHi,
I have a question regarding sql 2012 cluster 2 nodes
OS: Windows 2012 with AD
SQL: MS SQL Server 2012
Cluster: 2 nodesFirst time i'm going to install sql 2012 cluster for 2 nodes, like A and B. My question.
Shall i install cluster on both machine in A and B?
Shall i create ms sql database on both machine?
Shall i restore database on both machine ? like A and BLast, what are they requirement for installation such as Cluster Name, Domain admin, or Administrator on Domain Control admin rights?
Only on MS SQL Server side question.
Network card and Heartbeat, cluster ip, i have already.Thank you
Both machines need to have cluster services installed.
You cannot install the databases on both machines. A cluster is shared storage.
You may want to read these first
https://blogs.technet.microsoft.com/meamcs/2013/02/15/sql-2012-failover-cluster-build-step-by-step-part-1-installing-sql-2012/
https://www.brentozar.com/archive/2012/02/introduction-sql-server-clusters/
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
October 18, 2017 at 2:08 pm
Thank you, real appreciate your answer.
Ok, on both A and B machine i have to install cluster, thank you.
What about datebase? restore? on both machine A and B?
or singel machine?
So you mean, i have to create database on A machine and restore date, no need for Machine B?
Thanks
October 18, 2017 at 2:43 pm
stockholm - Wednesday, October 18, 2017 2:08 PMThank you, real appreciate your answer.
Ok, on both A and B machine i have to install cluster, thank you.What about datebase? restore? on both machine A and B?
or singel machine?
So you mean, i have to create database on A machine and restore date, no need for Machine B?Thanks
Your questions tell me that you have no understanding of how clustering works.
In a two-node active/passive cluster, SQL is installed on BOTH nodes. The articles I provided gave very good details on this. Did you read them?
During installation of SQL on a cluster, one of the things you provide is the virtual name for SQL server.
The virtual name is where you would restore these databases to. The databases do not live on BOTH nodes. The storage is shared between the nodes.
I suggest that you create your storage, make sure it can be accessed by the active node when you fail the cluster back and forth between the nodes.
You also need to cluster MSDTC.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
October 19, 2017 at 1:22 am
First off what type of HA is being implemented here? A typical failover cluster where you have shared storage, and one of the nodes has nothing running eg an Active Passive cluster. Or are you trying to implement Always On Availability Groups.
The two while utilize WFC are completely different to setup after the cluster has been configured.
October 19, 2017 at 12:30 pm
I am using Active and Passive cluster in 2 nodes
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply