Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2012 AlwaysOn Expand / Collapse
Author
Message
Posted Sunday, March 30, 2014 10:57 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 4, 2014 11:57 PM
Points: 67, Visits: 256
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



Post #1556325
Posted Monday, March 31, 2014 12:08 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
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."
Post #1556335
Posted Monday, March 31, 2014 1:57 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 4, 2014 11:57 PM
Points: 67, Visits: 256
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.

Post #1556370
Posted Monday, March 31, 2014 2:53 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
I doubt.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1556387
Posted Monday, March 31, 2014 3:54 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 4, 2014 11:57 PM
Points: 67, Visits: 256
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.


Post #1556401
Posted Monday, March 31, 2014 4:08 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:47 AM
Points: 6,306, Visits: 13,605
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"
Post #1556408
Posted Monday, March 31, 2014 9:32 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 29, 2014 1:14 PM
Points: 1,194, Visits: 2,217
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
Post #1556548
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse