When use snapshot, mirroring, log shipping or replication

  • Hey all,

    I'm studying for exam 70-431 and I'm getting confused with all the possibilities of using snapshots, mirroring, log shipping and replication. It's not clear to me when to use which one.

    Is there a rule of thumb when to use what?

    Any advise is welcome because I'm getting a bit of an overflow here ;-).

    Thanks.

  • Rule of thumb -

    snapshots for reporting databases

    mirroring and logshipping for High Availability or DR

    replication for scale-out (data available in more than one place).

    Thats not cast in stone thats what each technology is best for IMHO

    ---------------------------------------------------------------------

  • Thanks for the advise.

    Did exam 70-431 today and I passed.

    🙂

  • congratulations 🙂

    ---------------------------------------------------------------------

Viewing 4 posts - 1 through 3 (of 3 total)

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