Yeah, transactional replication is probably our only option until I get some real design time to re-engineer their systems. I am making a sandbox right now to test the...

They actually want reporting to be immediate as the departments here run the business off reports. Any new work is distributed or obtained from a report. So delays...

Hmm.... Interesting comments on log shipping and mirroring. I do not think mirroring would be ideal in this case as it requires a dual commit, if the reporting...