January 10, 2012 at 6:25 pm
We are launching a new application and for disaster recovery have decided on log shipping to the DR database. To prevent performance problems in production we are considering using the DR database for reporting. I was under the impression that Standby Mode wasn't a good option, but is the only way the database would be accessible with log shipping. Is it possible to run reporting from a database in Standby Mode that is receiving shipped transaction logs?
January 10, 2012 at 8:37 pm
Yes, you can run reports (read-only) against a database in standby mode. No, you can't apply transaction logs while reports are running against the database in standby mode, you have to terminate all connections to the database before the t-log can be applied during log shipping.
January 11, 2012 at 1:22 am
kwilt1 (1/10/2012)
I was under the impression that Standby Mode wasn't a good option
What gave you that impression!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 13, 2012 at 1:53 am
Perry Whittle (1/11/2012)
kwilt1 (1/10/2012)
I was under the impression that Standby Mode wasn't a good optionWhat gave you that impression!
The only thing not good about it is you need another licence as you're going to be querying the database.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply