We have users running reports using SQL server reportng services. The reports are currently running on the production database used by our ERP (GReat Plains).
We would like to have a mirror of this server and move the reports to run on this other server so there is no performance impact on Great Plains.
How can we create this mirror db and keep it in sync with production.
Please help. Thanks