What is the difference between a log and differential backup for SQL backups with Symantec Backup Exec?
Posted on 2014-07-22
I am currently running daily full backups of my SQL database with Backup Exec. I am trying to run log backups at noon but I get an error saying that the last backup job was not done by backup exec, which is not true. I found the tech article from Symantec that showed me how to do that and each time, backup exec is listed. So I thought of doing a differential backup.
Can someone tell me the difference between the log and differential backups?
With either, can I do backups every hour to keep a current backup?