locked
SQL 2005 / 2008 Data Mirroring RRS feed

  • Question

  • In SQL 2005 / 2008 Data Mirroring, can the Mirrored DB (standby DB) be active for reporting?  I can't do transactional replicatin because all of the tables in the DB do not have a Primary Key.


    Thanks,

    JB

    Monday, October 29, 2007 1:34 PM

Answers

  • You can't. However you can hang a database snapshot off the mirror and do reporting off that. It will get progressively more and more out of sync however.

    Monday, October 29, 2007 5:04 PM
    Answerer