We have a large environment supporting a third party application for 70 Clients having 70 databases. Now there is a requirement for a new reporting solution using readonly copies of live DB's. Our current platform is on SQL SERVER 2008 R2 CU5.I have looked into various options available. 1. DB Mirroring - mirrored databases are not available in readonly mode. 2. Replication - We have issues with primary keys and GUID's 3. logshipping - over head of maintaining 70 DB's , Network bandwidth, latency. Anyone have any thoughts or suggestions for using some sort of log shipping in this scenario?