How Do You Upgrade Log Shipping From SQL 2005 to SQL 2008R2?

• Motomoto

  Right there with Babe

  Points: 799

  More actions

  May 31, 2012 at 6:38 am

  #269656

  I currently have a log shipping implemented on SQL 2005 between my company and our vendor. The vendor's location is in Idaho and my company is in Indiana. We want to upgrade SQL 2005 to SQL 2008R2. What do I have to do in order to avoid my log shipping process to break and cause us to re-implement the entire process. Please advice.

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  May 31, 2012 at 6:39 am

  #1495177

  this link should help you out

  http://msdn.microsoft.com/en-us/library/cc645954%28v=sql.105%29.aspx