SQL Log Shipping

• Stuart Mundy

  Newbie

  Points: 3

  More actions

  November 22, 2004 at 4:45 am

  #162719

  Good Morning All,

  First off before I ask for help, I am very new to SQL, while I understand what SQL is etc I don't have much experience in administering it so please forgive my uber n00bness.

  Ok, we have a SQL clsuter here (A) consisting of two nodes and we have a single SQL server at our DR site (B). I have been tasked with setting up log shipping from A to B.

  Does anyone have or know where I would find a complete idiots guide to this? can anyone point me in the direction of previous posts (I did search but nothing that caters to a n00b)

  I assume that despite the fact that there in a cluster I can assign one node as a shipping partner and the other node as the monitor?

  I really am quite confused by all of this so any help wouold be warmly welcomed.

  Thanks for your time and patience,

  Stuart

• fperkins

  Ten Centuries

  Points: 1029

  More actions

  November 23, 2004 at 7:44 am

  #531216

   

  Perhaps this site would help.

  http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/hasog02.mspx