May 1, 2009 at 10:58 am
Ok, so I'm a newbie and in training and we are about to start talking about replication, before starting one person asked What is the difference between Standby Server and Replication? I've been searching all around, but have found nothing, I'm starting to believe it was just a "trick" question, Can you guys help me out a little bit?
Thanks
May 1, 2009 at 11:49 am
Standby Server would be relating to Log Shipping. You should be able to read through BOL for any information you need on that. Basically though it ships the transaction log backups to a "Standby Server" and can either apply them continually (thereby eliminating users from accessing the databases) or at set times (thereby allowing users to access them with somewhat stale data).
Replication has three different models primarily, snapshot (a full copy of the database), transactional (will migrate any transactions on the primary server to a secondary server) and merge (will update both databases with updates executed at either database).
Both solutions have their places. Replication in most places is used for scale-out type methodologies while Log Shipping is used for Disaster Recovery type solutions.
Definitely do some reading on both in Books On Line and you should find most of what you will need. Post back with more questions if you have them.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 1, 2009 at 11:49 am
Alternate thought too, Standby Server could also be referring to Database Mirroring. Again read up in BOL on that as well.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply