You could easily set the primary
and secondary servers to forward their alerts and copy their msdb.dbo.backuphistory
table information to a server. Essentially, that??™s what the automated method is doing.
At times, you may need to use a manual method for log shipping??”for example, when
communicating via FTP to a server not on your domain. Just because you use a manual
method doesn??™t mean that you cannot monitor the progress of the log-shipping process.
You can easily set up some alerts and copy the history tables by hand.
Log Shipping and Disaster Categories
How does log shipping help in terms of the five disaster categories? Well, it certainly
should help by getting a copy of your data off to remote location and minimizing the
impact of environmental disasters. However, it presents a problem for systems that
require high availability due to the length of time required for failover and failback.
Here??™s how log shipping affects each disaster scenario:
??? Environmental: Log shipping is one of the few mitigation techniques that focuses
on protecting data against environmental disasters.
Pages:
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335