Could someone here clarify the difference between replication and mirroring?
What I want to do is to be able to make a back-up of my database to a different computer, what are the things I need to do? Is it replication or mirroring?
TIA
Are do you looking to develop a high availability solution for your database from a primary server to secondary server.1. Database Mirroring (SQL 2005 SP1 only) allows real-time synchronous mirroring of the data.
2. Log Shipping allows mirroring of the log to a secondary machine
3. Replication (Merge & Transactional) allow alot more flexibility then the first two. They have a notion of a publisher and potentially many subscribers.
It is best to ask in the other (Mirroring or Replication) forums if you have more questions.
No comments:
Post a Comment