You could take help of database mirroring in thsi case and keep the mirroring server for reporting purpose to reduce the stress on live server in this case, further you can perform timely based mirroring for reporting purpose if you don't want to update reporting server database immediately. The...