MSSQL Backup schedule question- full/Full Differentail and transaction log backup
My question regarding the Full/Full Differential Schedule scenario in netbackup 7.5:
I will run a full backup every Friday and then full differential backup on monday-thursday.
imagine that the full backup job on Friday 12/4 and the full differential backup on monday 15/4 succeeds, then, on tuesday 16/4 the differential backup fails, on wednesday 17/4 the full differential succeeds.
if i would need to restore the database to the backup taken on wednesday 17/4 - will that be ok? will that backup
contain all the Changes between monday 14/4 and wednesday 17/4 (because the backup on tuesday failed)? Or is it required to run a full backup after the failed backup?
also, would there be a different answer if we backup transaction logs on the database every 30 minutes?
today we take Daily Full backups on many databases and that takes much time, thats why im looking at a different approach.