Missing differential backup may cause loss of data. In the case of database fault, we won’t be able to restore the database.
A Differential backup contains all the data in a specific database or set of file groups or files since the last Full backup.
A Differential backup cannot be executed without Full backup but it is smaller and faster to create than the base of a full backup and it also requires less disk space to store backup images
Differential SQL backup should execute successfully every 24 hours.
What went wrong?
- A large backup file causes long backup executes.
- No available disk space.
- The network is not available.
What to do:
- Check the backup system.
- Check server network connection