SQL 2005 Duplicated DB - 09-10-2010 , 03:29 PM
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.
Re: SQL 2005 Duplicated DB - 09-10-2010 , 03:49 PM
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!
On Sep 10, 3:29*pm, Jason <Ja... (AT) discussions (DOT) microsoft.com> wrote: