how setup Log shipping in local machine

• sakibd2k

  Valued Member

  Points: 74

  More actions

  June 16, 2010 at 5:22 pm

  #236599

  Hi,

  I am trying to get some answer from some one but not getting that much help.

  I have sql server 2000 developer edition , i have to create log ship in my local machine.

  So i have to create two instances for primary and standby or secondary server.

  Following lot BOL nothing actually work for me to set it up.

  at final window it stuck in saying initialize database ......

  and no maintainenace plan created ..

  where am i doing wrong can some one help plz?

• Denesh Naidoo

  SSCrazy

  Points: 2348

  More actions

  June 29, 2010 at 6:28 am

  #1186320

  Hi,

  When you setup your Secondary server...did you restore a Full Backup from your Primary server with NORECOVERY or with RECOVERY