April 18, 2012 at 11:43 pm
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
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
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
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
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
mhd_mhd (4/19/2012)
TanxOur 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
mhd_mhd (4/19/2012)
TanxOur 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