Forum Discussion

zak2011's avatar
zak2011
Level 6
13 years ago
Solved

SQL log truncation and Exchange log truncation

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!

2012
Backing Up
Backup and Recovery
Backup Exec
Basics
Best Practice
Tip-How to
Troubleshooting
  • pkh's avatar
    pkh
    13 years ago

    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.

  • pkh's avatar
    pkh
    Moderator
    13 years ago

    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.