Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Replication or Mirroring Expand / Collapse
Posted Thursday, August 1, 2013 3:27 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 23, 2015 8:41 PM
Points: 36, Visits: 112
We have an application that is starting to gain more users and is becoming more "critical" that it stay up. We would like to set up some sort of failover for our database server. Some of things we need to accomplish is: 1.) have the ability to make changes to live (source) database's structure that is then is copied over to the other (target) with very little intervention, 2.) Have it so if the source, goes down then the target can be used as the source.

I know that this is a little of both mirroring and replication, but which one, if any, could cover these two main points.

Thank you in advance,
Post #1480171
Posted Friday, August 2, 2013 1:47 AM



Group: General Forum Members
Last Login: Today @ 11:10 AM
Points: 7,964, Visits: 15,989
database mirroring would be the best solution for you here. Replication is more associated with replicating parts of a database rather than the whole database


"Ya can't make an omelette without breaking just a few eggs"
Post #1480289
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse