April 19, 2011 at 7:02 am
Hi All,
Currently, we have hot site and are building a warm DR site. We have a need to not only bring this data to the DR site but also other sites within our company but we are trying to minimize our bandwidth fees. I've had experience with log shipping but that does not seem to be an option because we want to move this data to the DR site and then push the data from the DR site to the other locations. The other locations need query access and under certain cases, they also need to update the data to test processes. The updated data does not need to go back to production. I hope I am making myself clear. I'll try to draw it:
Production ----> DR (via log shipping/replication)
DR ---> various other environments (other environments must be able to read the data and update it)
I am looking for recommendations.
Thanks!
April 19, 2011 at 11:02 am
Problem solved, we will use TLog shipping but use the WITH STANDBY command so the data can be read.
April 20, 2011 at 1:33 pm
Log shipping or DB mirroring for DR.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply