Our company is using MS SQL 2014 for an ERP application. We currently have a replicated server that has been set up with log shipping on the quater hour for the purposes of user reporting. (not SSRS, unfortunately)
If we set up log shipping in a friendly manner, then updates are delayed outside of an acceptable range. In its current configuration, reports are failing when run at the update event, connections lost. Our user base is about 1200 and will increase by a factor of 3 - 5 in the near future.
What is the proven method for replicating a ERP server for reporting purposes with little or no interuption? Log shipping, mirroring, etc.
Our needs are obvious; the concept is certainly not new to the professional world.