multiple log shipping to one instance

• Theo Broekmans

  SSC Rookie

  Points: 30

  More actions

  February 19, 2009 at 7:05 am

  #127849

  Hi there,

  I have a problem log shipping one primary database to two databases when the two secondary databases are restored on the same SQL2005 instance.

  SQL2005 lets you configure the second log ship database, but assigns the same copy and restore jobs that were made for the first log ship. This way I can not use different copy and restore schedules for the second log ship.

  In SQL2000 it worked fine. For each secondary database a different set of copy/restore-jobs was made.

  Can someone tell me whether I am doing something wrong or that it is just not possible anymore to have different schedules when log shipping one database two times to the same SQL instance?

  Thanks in advance,

  Theo

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  February 20, 2009 at 2:39 pm

  #947954

  I read somewhere that this is how its been confgured in SQL Server 2005, an enhancement to 2k...

  MJ