August 9, 2008 at 11:18 am
I want to offload reporting traffic from the live warehouse server. I think the following will work although I haven't attempted it yet.
1. Mirror the warehouse db to a mirror server.
2. Create a database snapshot based on the mirror server.
3. Run report server data-driven subscriptions running off the database snapshot.
4. Would it also be possible to use the mirror server as a hot standby based on this set up?
August 10, 2008 at 5:04 pm
Yes, however the snapshot is a point in time. It does not capture updates as the mirror changes.
You might need to periodically create a new snapshot to capture changes.
August 11, 2008 at 11:02 am
We actually use this method. I create snapshots at the "top of the hour" so people know that the data is refreshed then. Just make sure not to schedule report delivery at the time the snapshots are taken. It works out quite well for us.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply