My boss is refusing to switch the Verification on Transaction Log backup on,
as he feels it imposes an additional load on the server. I say that it
doesn't matter - if we need to ever recover from these logs, if they haven't
been verified and there's a problem we're in deep doo-doo. His answer is to
say that what's the chance of one failing anyway!
So my question is - What is the hit in terms of performance of verifying the
log backup.
Cheers
Andy
Hari Prasad - 30 Nov 2006 03:25 GMT
Hi,
Transaction log backup verify just checks the consistency of trasnaction log
backup files. So there will not be load to server. One more thing is
Transaction log backups are pretty
safe; so it is not required to verify each time...
Thanks
Hari
> My boss is refusing to switch the Verification on Transaction Log backup
> on, as he feels it imposes an additional load on the server. I say that
[quoted text clipped - 7 lines]
> Cheers
> Andy