Is something like the following viable, in a replicated scenario:
Take backup of the consolidated DB, then use this backup to extract client sites (instead of using the main running DB instance)?
asked 05 Sep '11, 05:48
I guess you are refering to the technique as described here:
It does use a copy of the consolidated database to extract data from there. It does tell how to take care that log offsets are fitting.
answered 05 Sep '11, 06:29