Link to home
Create AccountLog in
Avatar of mjs082969
mjs082969

asked on

SQL Server - Separate Database for Reports

What are the advantages and disdvantage to having any reports/queries running against a (very recent) copy of your production database rather than the actual production database?  

Obviously, the data in the copy/report database will be slightly old.  But what else?  Is this a good practice?

Thanks In Advance,

- Michael
ASKER CERTIFIED SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
And even space is not a problem if you use a database snapshot.
Avatar of mjs082969
mjs082969

ASKER

I have not used database snapshots extensively.  Can I ask how much space they normally take, in comparison to a copy of the database?  50%?
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account