SQL 2005 and Backup Exec causes Log File Problems
Posted on 2007-10-19
I have a microsoft sql 2005 x64 database(Windows 2003 x64 as well) which is extremely active and has grown to over 800gb in size in the past 60 days. We have our catalogs, logs, and database on 3 separate disks. The log disk is 65gb and in the past two years this has been more than enough space. We use simple logging in the database.
However, we created this new database two months ago and when using Backup Exec 11d, the backup process causes the log files to grow excessively filling up the disk. This of course fails the backup job and causes havoc with the database itself.
Prior to the database getting so large, we were able to use sql backup and successfully backup to disk with no excessive log file growth.
We suspect that the issue is the volume of transactions that is being pumped through the database between backup cycles. However, we cannot find any known issues and the Backup Exec support team is less than helpful.
We are trying to determine what causes the excessive log file growth...or any log file growth and any thoughts on what would fix this issue.