Log shipping remotely & transaction logs backups locally via maintenance plans

• Jas Lambert

  Newbie

  Points: 4

  More actions

  June 12, 2015 at 6:19 am

  #301517

  Hope you can help as I can't seem to find an answer!

  Background : We currently run a SQL 2008R2 2-node cluster, with a maintenance plan that backups up the transaction logs every 15 minutes along with a daily full backup overnight. All works well locally. However we are about to complicate matters by wanting to log ship to a secondary cluster for DR purposes.

  Will setting up log shipping to this other SQL cluster break the log chain / LSN on the local SQL cluster (as both the maintenance plan will run locally as well as the log shipping job)? Could we still restore a database just from logs from the local cluster? Or will we require both sets of logs from the local SQL cluster and the secondary SQL cluster?

  Ideally I would prefer to keep the log shipping process separate from the DR log shipping process but not sure if it possible? Any better ways of achieving it?

  Thanks

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  June 12, 2015 at 6:43 am

  #1805003

  Log shipping will break your existing backup plans.

  Use the log shipping transaction log backups to protect your database.

  Instead of relying on log shipping directly, you could roll your own using some Powershell. I have an example here[/url]

  -- Gianluca Sartori