How to log ship msdb

• abaig

  Old Hand

  Points: 364

  More actions

  January 19, 2004 at 1:33 pm

  #83911

  Hi,

  Does anyone know a way to logship msdb to standby server? I'm wondering how can I log ship the jobs created by our erp application. Anyone has any ideas?

   

• January 22, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  January 22, 2004 at 10:19 am

  #491154

  First you have to set MSDB database recovery mode to 'full' before you setup the logshipping.

  You can script the jobs and apply them to your standby server without logshipping the MSDB.