Eprs_Admin
asked on
SQL Logs backup
Hi Experts,
I need some recommendation for SQL backup.
Now I make the backup with Symantec BackupExec and the Agents.
This works well.
Regarding the LOG Backup I have some questions.
I have an incremental Backup and a differential backup of it.
But do I really need a differential backup of the LOGS ? Because each two hours I take a incremental backup.
The FULL backup is every day in the evening.
I need some recommendation for SQL backup.
Now I make the backup with Symantec BackupExec and the Agents.
This works well.
Regarding the LOG Backup I have some questions.
I have an incremental Backup and a differential backup of it.
But do I really need a differential backup of the LOGS ? Because each two hours I take a incremental backup.
The FULL backup is every day in the evening.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Of course in SYMANTEC you can have incremental and differential backup jobs of the DB.
I have set up one FULL per day and each 4 hours one DIFF.
But this is not neded more I think.
The LOGs I backup each 2 hours.
This is enaough for us.
Thanks.