TrialUser
asked on
mirror production sql server db to run reports
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.