| 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 |
|
|
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 ? |
 |
|
|
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) |
|
|
|
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 ?:( |
|
|
|
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.aspxAs 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). |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
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 :) |
|
|
|
Hecting
Starting Member
2 Posts |
Posted - 2015-01-28 : 05:24:26
|
| Oh I had the same query thanks @jrmtl for asking that |
|
|
|
jrmtl
Starting Member
9 Posts |
Posted - 2015-01-28 : 09:55:23
|
| ok :) |
|
|
|
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 KizerSQL Server MVP since 2007http://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 |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
SQL 2012 WFCI install question