MSSQL Backup schedule question- full/Full Differentail and transaction log backup
We have a customer with a large SQL database where daily full backup is taking too long.
They use NetBackup policies to schedule Weekly Full Backups, Daily Differential Backups and regular Transaction log backups. They run hourly log backups, but have also requested the ability to schedule more regular log backups, for example every 15 minutes.
To schedule backups more often that every one hour (e.g. every 30 minutes), the schedule needs to be changed from cmd:
bpplschedrep <POLICY_NAME> <SCHEDULENAME> -freq 1800
To get back to your question about the effect of failed Diff backup on Tuesday:
My understanding is that Wednesday's backup will include all changes since last successful backup (Monday).I agree with Mark - you would be fine.
Just one more thing: please ensure that your environment is patched up to NBU 7.5.0.5. There was a bug in the SQL restore GUI up to version 7.5.0.4:
Extract from NBU 7.5 LBN:
(ET2990617) <<Fixed in 7.5.0.5>> <<Fix Downloadable>> When a transaction log backup image for restoring from the SQL Agent is clicked on, the agent crashes.
http://www.symantec.com/docs/TECH201595