February 15, 2005 at 8:32 am
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.
February 16, 2005 at 3:53 am
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply