SQL 2005 Duplicated DB

[Jason]

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!

[Ben Thul]

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

Post by Jason
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!