Hello,
I'm trying to find the right solution for having a read only copy of my
production database for reporting. It needs to be no more then 1 hour old. It
will need to be read by SAP Business Objects.

With Mirroring the Mirror is in recovery mode so i cannot read it.
Transactional replication might take to long.

What would be the best solution? Hardware, Software, Etc.


Thanks!

I think that you can create a database snapshot (SQL 2005+) of a
mirrored database. However, I wonder why you're saying that
transactional replication would take too long? Once replication is
established and caught up, it shouldn't ever be behind by more than a
few minutes. Set it up and see what happens!
--
Ben
On Sep 10, 3:29*pm, Jason <Ja... (AT) discussions (DOT) microsoft.com> wrote: