Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

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

1 Answer 1

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.

share|improve this answer
    
but in this scenario would Database3 also failover (obviously without the data replicating)? –  user33114 Jan 20 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 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 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 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 at 14:36

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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