Site 1 , Server A and B (Production)

Site 2 ,Server C and D  (Pre-production)

Site 1 is production and Mirroring is happening between A and B

i need to push data from site 1 to site 2 and then set up DB Mirroring from C to D for pre-production instances , i cant setup Log shipping and Mirroring for Pre-prod from A or B as i need Pre-prod C instance available for updates as well.

as of now i am thinking of weekly restore of production backups on pre-prod C instance and turn on Mirroring for D pre-prod instances ,any better solution with less admin. tasks?

HI,

You can choose any one of the below approaches.

 
1. Configure Log shipping between site 1 to site 2, this approach will require more admin then the latter two.

2. Configure snapshot replication from site1 to site 2 and run the agent every week either on sat or sun night. This approach will requir less admin then thr 1st one.

3. Create a job to restore the full backup ( given that u must be taking full backups atleast once a week) from site 1 to site 2 and then turn on mirroring. this approach will require least admin out of the three.

Tell me if this helped.