Database Mirroring for Reporting RRS feed

  • Question

  • I am considering setting up a SQL 2008 database mirror of the org_MSCRM database to another SQL 2008 server and using the mirrored copy for reporting.  The idea here is to have reports pointed to the copy so the production instance is not affected by poorly formed queries/reports, but the data is still 'up to date' from production.

    I haven't set this up before, so I have a question about adding indices to the mirrored copy that will not exist on the production master copy?  Can you do this with mirroring, or does it have to be an exact copy?

    Monday, May 10, 2010 3:14 PM