How do you run reports on your production data without impacting business? It’s a fairly common predicament. In quite a few cases, I’ve come across a fairly obvious solution: Replicate your data every night and run the reports on the replica. The approach generally runs something like this: Shut down or quiesce the production database Back it up Restart or unquiesce the production database Copy the backup across the local area network to a reporting ...

REGISTER NOW TO ACCESS THIS ARTICLE

All registered users get access to premium content on POWER IT Pro for free.

Already registered? Log in here.