asked on

SQL 2005 logs not flushing and taking up space

Hi Guys,
I've got an SQL database that takes up what little space we have on the drive, we run the shrink command on it and manage to get back about 7GB each time but we also have Symantec Backup Exec installed with the SQL agent and were under the impression that this would flush the logs when the backup had completed.
Does having the database in Simple or Full mode affect this and if not then what could be going wrong or what can we do ?

Thanks

Iamthecreator

Backup Exec does not Flush the logs when you perform a FULL DATABASE BACKUP
Run a backup of the LOGS

Backing up SQL transaction logs
http://support.veritas.com/docs/300158

Setting backup options for SQL
http://support.veritas.com/docs/310364

Also check the following for a better understanding of how SQL backups work

How do the Simple, Bulk-logged, and Full Recovery modes in Microsoft SQL 2000 apply to Backup Exec?
http://support.veritas.com/docs/236600

The size of the log file does not decrease when performing a backup operation of Microsoft SQL although the "truncate log on checkpoint" option was selected
http://support.veritas.com/docs/233168

After performing "Log - Backup Transaction Log" of SQL databases using Backup Exec, the size of the physical log file remains unchanged.
http://support.veritas.com/docs/270043

Netexperts

ASKER

Thanks for that but the information isn't that clear. Does this mean that i need to setup a seperate Backup Exec job to just backup the Transaction logs ?

Thanks

ASKER CERTIFIED SOLUTION

Iamthecreator

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Netexperts

ASKER

Makes sense now.
Many Thanks