I have a need to be able to automatically failover my databases and most need data replication. However, one database does not need data replication and so, for performance reasons, we do not include that in the auto failover plan since it requires data replication. Is there a way to disable data replication for certain databases?

  • What technology are you currently using? Failover Cluster Instance? AlwaysOn Availability Groups? SQL Server Replication? – Thomas Stringer Jan 20 '14 at 13:41
  • Sql Server Replication/Mirroring - but may move to AlwaysOn Availability groups. – user33114 Jan 20 '14 at 13:55

Judging by your comment, it sounds like you are looking to make the move to AlwaysOn Availability Groups. The way that availability groups work is that you choose which databases are added to the availability group and are therefore part of the high availability implementation.

So in other words, if you want Database1 and Database2 to be highly available with automatic failover, then you configure a partner to have synchronous commit and be an auto failover partner, and when you create your availability group you add those two databases to the availability group. But if you don't want Database3 to be part of that topology, then you simply don't do anything with that database regarding the availability group.

  • but in this scenario would Database3 also failover (obviously without the data replicating)? – user33114 Jan 20 '14 at 14:09
  • No, Database3 isn't part of the availability group, so it is not "living" on the other replicas/servers. So, no, it wouldn't be part of any failover with this layout. Is that not the desired effect? – Thomas Stringer Jan 20 '14 at 14:12
  • right - so what I need is Database3 to failover along with the others - but I don't want the data replicated for Database3. – user33114 Jan 20 '14 at 14:13
  • Then put Database3 in the same availability group. You don't want the data replicated for this database? Maybe I'm a bit confused, but then don't set up replication for that database. If that's not what you mean, please define "replicated" and what in particular you mean by that. – Thomas Stringer Jan 20 '14 at 14:24
  • By replication - I mean when it fails over the database it fails over to should be empty (it does not need the data). I will need data replicated for the other databases but not for this particular one. Am I am able to set it up to do this? – user33114 Jan 20 '14 at 14:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.