Replication or Mirroring

  • 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

  • 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" 😉

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply