How to setup Log shipping between 2 SQL 2000 Servers(Standard Edition)

• SqlServer Rocking

  SSChasing Mays

  Points: 605

  More actions

  September 3, 2010 at 1:01 pm

  #239934

  I need to setup Log shipping between 2 SQL 2000 Servers(Standard Edition).

  >I know Microsoft don't support Log Shipping for the Standard Edition but I

  >hear you can setup a manually process. Can someone help me with this one?

  Thanks,

  Srikanth

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  September 6, 2010 at 2:37 pm

  #1217047

  try this. Written for SQL7 but works equally well in SQL2000.

  worked seamlessly for me for years.

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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736150

  More actions

  September 8, 2010 at 4:16 pm

  #1218294

  Here are a few more:

  http://www.sqlservercentral.com/articles/Administration/customlogshipping/1201/

  http://www.sqlservercentral.com/articles/Log+Shipping/70506/