SQL Server 2008 Log File
I get the following for each database on SQL Server 2008 R2 that is backed up;
V-79-40960-37914 Database Archives is configured to maintain transaction logs. Transaction log backups are not being performed. This will result in the log growing to fill all available disk space. Regular log backups should be scheduled or the database should be changed to the simple recovery mode.
I did the following;
HKEY_LOCAL_MACHINE\SOFTWARE\Symantec\Backup Exec for Windows\Backup Exec\Engine\SQL Server\Number of Non-Log Backups Before Warning
The default value is a decimal value of 10
Increasing this value will increase the number of full database backups it will take to display the exception
Setting the value to 0 will disable this exception from ever occurring. Symantec does not recommend setting this value to 0.
Where I set the registry key to zero to disable this, but Backup Exec 2010 R2 continues to complain about this in the log and flagging the backup as ended with exceptions. I've even restarted all the services just to ensure the key was picked up properly.
I also find it disappointing that given the cost of this product, this becomes an issue backing up the SQL databases. When doing a full backup of the systems and including the SQL databases, it should do what is required to handle the logs without having to create a sepaarte backup for this purpose.
So even though the registry key has been set to 0, why does is this not disabled and so eliminate this as a backup warning?