How to create log shipping using T-sql(NO WIZARD)

• klnsuddu

  SSCertifiable

  Points: 5836

  More actions

  May 18, 2009 at 3:08 pm

  #155721

  Hi,

  Could you please tell me the best method to configure Log shipping using T-sql. We have 16 databases in sql server 2005(databases of share point application) and need to configure log shipping for all of them.

• sql_lock

  SSCrazy Eights

  Points: 9373

  More actions

  May 21, 2009 at 6:25 am

  #998191

  Have you tried setting one up and using the "Script Configuration" option within the Log Shipping GUI?

  I have attached a "mock" one.