Log shipping for reporting purpose

• EasyBoy

  SSCertifiable

  Points: 5301

  More actions

  May 6, 2016 at 10:04 am

  #316291

  We are using SQL server 2008 for all activities (including reporting). Due to heavy load, now we would like to setup separate server for Reporting purpose only using log shipping features. Would it be possible with very less latency?

  Thoughts please?

• djj

  SSCoach

  Points: 18831

  More actions

  May 6, 2016 at 11:20 am

  #1877218

  Watch reading from a log shipped database as connections may be dropped during update.