Adding one more secondary database in logshipping is giving error

• forsqlserver

  SSCoach

  Points: 18902

  More actions

  April 29, 2011 at 3:03 am

  #238691

  I have configured Logshipping on Mirroring Database.It is running fine.

  Now I want to add one more database from DR Site in the Logshiping configuration 'Secondary Databases' tab.Then I am getting error:

  TITLE: Transaction Log Shipping Destination Settings

  ------------------------------

  The new values for the copy destination folder and/or copied file delete time will also affect other secondary instances.

  ------------------------------

  BUTTONS:

  OK

  ------------------------------

  😉

  Thanks

• Geoff A

  SSChampion

  Points: 11511

  More actions

  April 29, 2011 at 7:56 am

  #1317807

  its telling you that the first DB that is running log shipping is using that directory.

  when you add the second DB to the same directory structure, the delete function will hose your backup chain.

  use another directory for the second DB being added.