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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Availability Groups and DR (2012)
 SQL 2012 WFCI install question
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jrmtl
Starting Member

9 Posts

Posted - 01/24/2015 :  22:31:24  Show Profile  Reply with Quote
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

Edited by - jrmtl on 01/24/2015 22:32:52

gbritton
Flowing Fount of Yak Knowledge

2780 Posts

Posted - 01/25/2015 :  10:03:39  Show Profile  Reply with Quote
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 - 01/25/2015 :  18:28:36  Show Profile  Reply with Quote
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 ?

Edited by - jrmtl on 01/25/2015 19:06:25
Go to Top of Page

gbritton
Flowing Fount of Yak Knowledge

2780 Posts

Posted - 01/26/2015 :  09:08:56  Show Profile  Reply with Quote
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 - 01/26/2015 :  13:37:27  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

2780 Posts

Posted - 01/26/2015 :  14:01:21  Show Profile  Reply with Quote
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

USA
38200 Posts

Posted - 01/26/2015 :  14:01:31  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 01/26/2015 :  19:37:07  Show Profile  Reply with Quote
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 - 01/28/2015 :  05:24:26  Show Profile  Reply with Quote
Oh I had the same query thanks @jrmtl for asking that
Go to Top of Page

jrmtl
Starting Member

9 Posts

Posted - 01/28/2015 :  09:55:23  Show Profile  Reply with Quote
ok :)
Go to Top of Page

jrmtl
Starting Member

9 Posts

Posted - 02/10/2015 :  10:37:57  Show Profile  Reply with Quote
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

USA
38200 Posts

Posted - 02/10/2015 :  15:35:00  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000