Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Availability Groups and DR (2012)
 SQL 2012 WFCI install question

Author  Topic 

jrmtl
Starting Member

9 Posts

Posted - 2015-01-24 : 22:31:24
Hello all,

I have a similar question as the posts in this forum but what I need to accomplish is to allow an instance to fail over completely to another node seamlessly as new databases are constantly being created at random by an application and I am not sure I understand how to implement the "availability groups " step if at all ?

I am trying to install SQL Server 2012 "AlwaysOn Failover Cluster Instance"

much appreciated ( as I'm also new to this cluster install )

JR

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-01-25 : 10:03:39
That's a pretty big topic.

Work your way thought this series of articles:

http://www.sqlservercentral.com/stairway/112556/

then come back if you need more help.
Go to Top of Page

jrmtl
Starting Member

9 Posts

Posted - 2015-01-25 : 18:28:36
Thanks for that :)

For the most part the windows failover sections which are about 80% of the install is fine.
The section mentioning FCI doesn't have much information on the step by step.

My question and what confuses me is how I can configure it to fail over a complete instance without the AG adding of databases individually ?
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-01-26 : 09:08:56
You need to add the databases individually, though of course you could script that using sp_MSforeachdb. (undocumented)
Go to Top of Page

jrmtl
Starting Member

9 Posts

Posted - 2015-01-26 : 13:37:27
So you are saying that with the FCI feature it cannot fail over the instance ( and whatever DB it contains ) or when newly databases are added ?

:(

Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-01-26 : 14:01:21
Sorry, I was confusing AOAGs with AOFCI. but from the doc, you can do what you want:

https://msdn.microsoft.com/en-us/library/ms189134%28v=sql.110%29.aspx

As part of the SQL Server AlwaysOn offering, AlwaysOn Failover Cluster Instances leverages Windows Server Failover Clustering (WSFC) functionality to provide local high availability through redundancy at the server-instance level—a failover cluster instance (FCI). An FCI is a single instance of SQL Server that is installed across Windows Server Failover Clustering (WSFC) nodes and, possibly, across multiple subnets. On the network, an FCI appears to be an instance of SQL Server running on a single computer, but the FCI provides failover from one WSFC node to another if the current node becomes unavailable.

An FCI can leverage AlwaysOn Availability Groups to provide remote disaster recovery at the database level. For more information, see Failover Clustering and AlwaysOn Availability Groups (SQL Server).

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-01-26 : 14:01:31
Availability Groups are different than FCI. An FCI fails the entire instance over. An AG fails a group of databases over. To get databases into an AG, you have to add them. Adding them can be automated, but I don't think you are interested in AGs anyway. Just implement FCI.

They are two different but similar technologies under the AlwaysOn umbrella.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jrmtl
Starting Member

9 Posts

Posted - 2015-01-26 : 19:37:07
Thank you both for your help ... greatly appreciated as I am learning SQL server 2012 and especially this FCI as I go here and just wanted to make sure as it can really get complex :)

I will report back on the progress of the install :)
Go to Top of Page

Hecting
Starting Member

2 Posts

Posted - 2015-01-28 : 05:24:26
Oh I had the same query thanks @jrmtl for asking that
Go to Top of Page

jrmtl
Starting Member

9 Posts

Posted - 2015-01-28 : 09:55:23
ok :)
Go to Top of Page

jrmtl
Starting Member

9 Posts

Posted - 2015-02-10 : 10:37:57
quote:
Originally posted by tkizer

Availability Groups are different than FCI. An FCI fails the entire instance over. An AG fails a group of databases over. To get databases into an AG, you have to add them. Adding them can be automated, but I don't think you are interested in AGs anyway. Just implement FCI.

They are two different but similar technologies under the AlwaysOn umbrella.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/



Hello tkizer,

Would there be a way to configure a a replciation of the databases within a FCI to another site through mirroring ? all new databases would have to be automatically added to get replicated.

thx
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-02-10 : 15:35:00
Yes you can mirror the databases to another site. If you need it to happen automatically when you add a database to the primary site, then you'll need to develop scripts to do it. It's not a built-in feature to auto-add to mirroring.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -