Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replication or Mirroring Expand / Collapse
Author
Message
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: Saturday, June 7, 2014 12:06 PM
Points: 33, Visits: 95
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,
Jim
Post #1480171
Posted Friday, August 2, 2013 1:47 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:08 AM
Points: 6,162, Visits: 13,305
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