cancel
Showing results for 
Search instead for 
Did you mean: 

SQL log truncation and Exchange log truncation

zak2011
Level 6

Currently i am taking a Full backup of an SQL database with specific retension period  from one of the SQL servers using Backup Exec   and keeping a retension time of 100 day. No backups are taken using the SQL management studio. If i continue this approach, will the log size on the SQL server grow indefintely and lead to space issues on the SQL server?

In the case of  Exchange Server , does the transaction logs get truncated when i do a Full and incremental backup using Backup Exec or does it get truncated only when incremental backups are done.

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions

pkh
Moderator
Moderator
   VIP    Certified

For SQL, you have to run a job to backup the transaction logs and it will truncate it at the same time.  Otherwise the log will just grow.  In your backup job, just add another job to backup the logs.

For Exchange, when you do a full or incremental backup, logs will be truncated.

View solution in original post

2 REPLIES 2

pkh
Moderator
Moderator
   VIP    Certified

For SQL, you have to run a job to backup the transaction logs and it will truncate it at the same time.  Otherwise the log will just grow.  In your backup job, just add another job to backup the logs.

For Exchange, when you do a full or incremental backup, logs will be truncated.

zak2011
Level 6


Thanks pkh