title: Database mirroring for report database
body: <p>I have a problem that our production database is under heavy load.
  So we have decide that we setup a second SQL server running copy of production database that doesn't need to be 100% uptodate with production database.</p>
  
  <p>After searching I have found that asynchronous mirroring of production database might do the trick.
  Mirror database would be only read-only for reports and stuff.
  So I managed to set it up, but have found out that I can't read any data from mirror database because it is in recovery mode.</p>
  
  <p>No I would like to know if my problem is solvable with mirroring or we should use alternative? </p>