Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dave Watts
Starting Member
4 Posts |
 Posted - 2007-04-26 : 11:09:42
|
| I am in the process of having to design a log shipping solution. I have a Primary server in location A and a warm standby server in location B. I aim to have a seperate monitor server in location B (standby site) is this the correct approach ?Are there any issues in having the Warm Standby server also being the monitor server ?Does the monitor server need to be highly redundant ?What is the impact on the log shipping process if we were to lose the monitoring server ?What if there was a large increase of utilisation on the monitor server (for other processing) would this affect the Log Shipping ? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-26 : 12:59:29
|
| We put the log shipping monitor at the primary site. We due this since our secondary site isn't running production so those servers can be rebooted/patched/maintained at all hours of the day. The monitor server is not all that important for log shipping. You can still see log shipping problems if you monitor for failed SQL jobs.If you lose the monitoring server or have increase in utilization on that server, it will have zero impact on logshipping.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Log Shipping Monitor questions