Forum Discussion

Vdang's avatar
Vdang
Level 4
11 years ago

Maintain Transaction Logs.

Hello Gents/Ladies, I have been having issues with my backup job lately and it is with regards to SQL Server backups. I have been getting the follow error messages and I am unsure how t...
2012
Agent for Microsoft Exchange Server
Agent for Microsoft SQL Server
Backing Up
Backup and Recovery
Backup Exec
Best Practice
Deduplication Option
Error messages
Tech Support
  • pkh's avatar
    pkh
    11 years ago

    Since you maintain transaction logs, you need to clear the logs.  Otherwise they will grow and fill up your disks.  See my article below on how to backup and clear your transaction logs.

    https://www-secure.symantec.com/connect/articles/how-backup-sql-logs-and-truncate-them-be-2012

MusSeth's avatar
MusSeth
Level 6
11 years ago
Hello vdang, In addition to kunal and pkh make sure to run log backup and not log no truncate backup....please have a look at the article below http://www.symantec.com/docs/HOWTO73853 FYI : once logs are backed they will be truncated however disk space will not be reclaimed which was used by this logs in order reclaim disk space you would have to use dbcc shrink or in sql management studio use option to shrink database files and database...