<div>
ok, now I understand.<br />
Of course in SYMANTEC you can have incremental and differential backup jobs of the DB.<br />
I have set up one FULL per day and each 4 hours one DIFF.<br />
But this is not neded more I think.<br />
The LOGs I backup each 2 hours.<br />
<br />
This is enaough for us.<br />
&nbsp;Thanks.
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I need some recommendation for SQL backup.<br />
Now I make the backup with Symantec BackupExec and the Agents.<br />
This works well.<br />
Regarding the LOG Backup I have some questions.<br />
I have an incremental Backup and a differential backup of it.<br />
But do I really need a differential backup of the LOGS ? Because each two hours I take a incremental backup.<br />
The FULL backup is every day in the evening.
</div>
</div>


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.

SQL Logs backup

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

The term "Backup" means the methods and processes involved to copy computer data (system data as well as application data) to media other than the ones where the data originally live (disk, tape, optical, cloud). "Restore" in turn means the methods and processes involved in data recovery, i. e., bringing back copied computer data to their original location. Backup/Restore primarily serves as a means of protection against data loss, be it due to disaster, corruption or sabotage. It can also be used for recovering data from an earlier point in time and even for cloning machines or applications. There is a wide variety of backup/restore software available, from expensive commercial products to free or open source tools.