locked
1hour RTO and 1 Min RTO on sql 2008R2 RRS feed

  • Question

  • Hi All,

    I am trying to achieve a 1 hour RTO and 1 Min RPO on a SQL 2008 with a DR. ( 100MB link between primary an secondary DC)

    the size of the db is 200GB and the number of users is about 300.

    What is the best way of doing it using Mirroring/ Log shipping?

    Thank you

    Wednesday, June 20, 2012 1:42 PM

Answers

  • No, the DB is synced constantly, so normally you are only a few seconds behind...

    Lucifer

    • Marked as answer by amber zhang Wednesday, June 27, 2012 9:31 AM
    Wednesday, June 20, 2012 3:51 PM

All replies

  • Hi Ouartil!

    Well, 1 Min RPO is pretty hard to do with LogShipping, so the best option for you would most likely be Mirroring. With an Async DB Mirror between the sites you should be able to fulfill those needs pretty much without any problems, provided that your link between the sites is stable.

    Cheers

    Wednesday, June 20, 2012 2:38 PM
  • Thank you for your answer,

    with Async mirroring, is there a parameter to configure so the DB are syncked every 1 min?

    Thank you

    Wednesday, June 20, 2012 2:59 PM
  • No, the DB is synced constantly, so normally you are only a few seconds behind...

    Lucifer

    • Marked as answer by amber zhang Wednesday, June 27, 2012 9:31 AM
    Wednesday, June 20, 2012 3:51 PM
  • to acheive 1 min RPO  go for MIrroring ,CLustering is aslo a good idea

    Friday, June 22, 2012 8:42 AM