SQL 2012 AlwaysOn

Question

Post reply

SQL 2012 AlwaysOn

adeel.imtiaz

SSCommitted

Points: 1805
More actions
March 30, 2014 at 10:57 pm

#306024

Dear Gurus,
I have a SQL Cluster with the followings.
Windows Server 2008 R2
SQL Server 2012
Shared Storage(SAN)
Now i have another requirement of SQL Server 2012 AlwaysOn which a news feature in SQL Server 2012 for HA and DR. Your kind support is required for the below clarification.
For a two node AlwaysOn
Do we need a Shared Storage(SAN) for SQL Server 2012 AlwaysOn
Do we need to have independent storage on each node for db restoration.
do we need to install SQL Server 2012 on each of the node with same and independent instance
Please suggest with your goodself and i will be very thankful if any specific Web Link /video Link is shared.
Regards.
Adeel Imtiaz

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

free_mascot One Orange Chip Points: 27169 More actions · Answer 1

Refer following article:

http://www.sqlservercentral.com/articles/FCI/92196/

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

adeel.imtiaz SSCommitted Points: 1805 More actions · Answer 2

Thanks Team, and i have few more queries and need your kind expert opinion.

if i have to build a two node SQL cluster with shared storage and always on, is there any possibility.

Thanks.

free_mascot One Orange Chip Points: 27169 More actions · Answer 3

I doubt.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

adeel.imtiaz SSCommitted Points: 1805 More actions · Answer 4

Dear Guru,

can i please share further clarification about it. i can do it or not.

<<can i build a two node sql cluster with Shared storage(SAN) with AlwaysOn>>

OR

I have to go wthe the second scenerio as mentioned in the link shared by you.

i have a very important assignment and i am waiting for this query to resolve.

Thanks.

Perry Whittle SSC Guru Points: 233821 More actions · Answer 5

adeel.imtiaz (3/30/2014)
Do we need a Shared Storage(SAN) for SQL Server 2012 AlwaysOn

No, not for a standard AlwaysOn configuration involving replicas that are standalone installs of SQL Server

adeel.imtiaz (3/30/2014)
Do we need to have independent storage on each node for db restoration.

Again, same as above.

If you have standalone instances as your AlwaysOn replicas they each have their own local storage, this can of course be SAN presented.

adeel.imtiaz (3/30/2014)
do we need to install SQL Server 2012 on each of the node with same and independent instance

Yes, a standalone instance would be deployed to each node that is to host an AlwaysOn replica.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 6

adeel.imtiaz (3/30/2014)
Dear Gurus,
I have a SQL Cluster with the followings.
Windows Server 2008 R2
SQL Server 2012
Shared Storage(SAN)
Now i have another requirement of SQL Server 2012 AlwaysOn which a news feature in SQL Server 2012 for HA and DR. Your kind support is required for the below clarification.
For a two node AlwaysOn
Do we need a Shared Storage(SAN) for SQL Server 2012 AlwaysOn
Do we need to have independent storage on each node for db restoration.
do we need to install SQL Server 2012 on each of the node with same and independent instance
Please suggest with your goodself and i will be very thankful if any specific Web Link /video Link is shared.
Regards.
Adeel Imtiaz

Could you let us know why you want to set up Always ON availability groups on the SQL Server cluster, external to the SQL Server failover cluster instances on the same cluster ?

--

SQLBuddy