Post reply

how can i have an online sync standby database in sql server

  • April 18, 2012 at 11:43 pm

    #260165

    i have a standby database in sql server(2008). backup from primary database and copy logs and restoring Occur every day every 10 seconds ,but i have latency in standby database,how can i solve this?

    i want an online standby database.

    i cannot DECREASE the time in schedule, it deny second less than 10 in sql server.

  • April 19, 2012 at 12:13 am

    #1475837

    mhd_mhd (4/18/2012)

    i have a standby database in sql server(2008). backup from primary database and copy logs and restoring Occur every day every 10 seconds ,but i have latency in standby database,how can i solve this?

    i want an online standby database.

    i cannot DECREASE the time in schedule, it deny second less than 10 in sql server.

    Then you should go for Transactional Replication.

    Log-Shipping is not the right solution this requirement.

  • April 19, 2012 at 12:19 am

    #1475841

    mhd_mhd (4/18/2012)

    i have a standby database in sql server(2008). backup from primary database and copy logs and restoring Occur every day every 10 seconds ,but i have latency in standby database,how can i solve this?

    i want an online standby database.

    i cannot DECREASE the time in schedule, it deny second less than 10 in sql server.

    What is your goal? DR (disaster recovery) or real time reporting?

    If your goal is DR, you can consider Mirroring.

    If your goal is real time reporting, consider Transactional Replication.

  • April 19, 2012 at 12:20 am

    #1475842

    You are describing log shipping. There will be some latency involved when you are dealing with log shipping.

    By the by, what is the latency duration.

    Why do you want to make the secondary database online?

    M&M

  • April 19, 2012 at 12:42 am

    #1475854

    Tanx

    Our data is so important and i dont want to loose any data

    also i need online reporting

    the primary database and standby are in one instance

  • April 19, 2012 at 12:47 am

    #1475859

    mhd_mhd (4/19/2012)

    Tanx

    Our data is so important and i dont want to loose any data

    You won't lose any data

    M&M

  • April 19, 2012 at 2:32 am

    #1475890

    mhd_mhd (4/19/2012)

    Tanx

    Our data is so important and i dont want to loose any data

    also i need online reporting

    the primary database and standby are in one instance

    Keeping the primary database and standby in the same instance, is NOT a good plan from DR and performance point of view.

Viewing 7 posts - 1 through 6 (of 6 total)

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