Questions about Log Shipping ?

• Summer90

  SSC-Dedicated

  Points: 32864

  More actions

  February 15, 2005 at 8:32 am

  #87528

   We are looking to setup log shipping to another datacenter for some of our critical SQL Servers. In reading everything I have found I have a couple of questions.

  1.) Monitor server, what kind of hardware does this require? Would a low end server be sufficient? Does this require much processing power, memory etc... I would assume it does not.

  2.) If you want to log ship say 3 different servers databases to 3 different servers at another site can this be monitored from 1 monitor server or does there have to be 3 monitor servers ?

  3.) Does mixing operating systems the originating server of Win2000 with the monitor server and or destination server with Win2003 pose any problems ?

  Any experience and or wisdom would be appreciated about Log Shipping in general.

   

   

• athurgar

  SSCrazy

  Points: 2816

  More actions

  February 16, 2005 at 3:53 am

  #542485

  1. I usually use the primary server that I am log shipping from, but it can be any SQL Server. Doesn't require large resources.

  2. You can monitor from 1 centralised server.

  3. No issues with different OS's, but have made sure that SQL is always running EE.