SQL Server Performance

Log Shipping for Many Large Databases

Discussion in 'ALL SQL SERVER QUESTIONS' started by murali, Feb 14, 2012.

  1. murali New Member

    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?
  2. Asheesh pandey New Member

    Murali,
    I think log shipping is the best option for reporting purpose in above three...
    while you are using sql server 2008 r2 then you can also use snapshot with mirroring but it is static.

Share This Page