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.
| Author |
Topic |
|
NguyenL71
Posting Yak Master
228 Posts |
 Posted - 2015-03-11 : 11:44:09
|
| I was given a task to do a Database FailOver in SQL 2012 and I wonder has anyone had done this before or have good documentationhow to set it up and how to Failover to other nodes (Databases only). I was under impression to fail the whole instance insteadof the entire databases. I also google it to see if any good resources out there.Thank you so much in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-03-11 : 11:58:02
|
| You can use Availability Groups to failover databases. What edition of SQL Server do you have?For instance-level, it's Failover clustering.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
NguyenL71
Posting Yak Master
228 Posts |
Posted - 2015-03-11 : 13:47:01
|
We using SQL Ent 64 Edition. Can you failover the DBs Only not the entire Instance. One of our DBA said with SQL 2012 Always On, you can fail over Only Databases. I thought you have to fail the whole instance, I might be wrong. Please help to clarify that.Thank you.quote:
Originally posted by tkizer
You can use Availability Groups to failover databases. What edition of SQL Server do you have?For instance-level, it's Failover clustering.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-03-11 : 14:17:48
|
| Your DBA is correct that Availability Groups (don't call it AlwaysOn as that's a broad term that includes AGs and Failover instances) can failover the databases. It's a new technology and is done at the group level and NOT the instance level.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
How to set up DB FailOver Always On SQL 2012