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.