asked on SQL Server Replication for Reporting
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.
Thank you.
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.
Thank you.
Microsoft SQL Server
Last Comment
Vitor Montalvão
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Are you on SQL Server Enterprise or Standard?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.