Problems with understanding the safety of logging and
the backup of logging.
One single machine. With a one set of disks which are mirrored.
Regular full backups. (Say each 24 hours)
Very regular log backups. (Say each 10 minutes).
Suppose something goes wrong with the backup of the
log. (The backup file is lost or corrupted).
If the log was truncated then the system is vunerable until the
next full backup, or incremental backup. Is this true ?
If the log was not truncated, can this log be used again to
backup this log ? As far as I understand you cann't do that.
Or is this possible ?
Is it possible to have logging taking place real time on two
very different locations, to protect against callamities ?
(The issue here is dataloss, and although performance and
availability are important that is not the issue here).
Thanks for your thoughts,