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
TrialUserAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Chris WongConnect With a Mentor Commented:
SQL Server 2008 R2 : Database Snapshots - Setting Up Snapshots Against a Database Mirror

http://sportstoday.us/technology/sql-server-2008-r2---database-snapshots---setting-up-snapshots-against-a-database-mirror.aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.