SBE12.5 won't flush SQL logs
Good morning. I am running SBE12.5 on Windows 2008 x32 and all are patched with the latest patches, etc. I am having problems with backing up SQL 2005 on a Windows 2003 x32 server (patched also). For some reason, my backups are not truncating the SQL transaction logs. The SQL recovery model is set to FULL and the SQL server only has one instance on the server. I am using policies to run the backups and I am backing up to an HP tape library. One item that I will mention (which I just found out yesterday) is that SQL integration services is not installed on the SQL server. When i went to create a SQL maintenance plan last night, I was unable to do so because SQL IS isn't installed. I don't know whether or not that is required for SBE to flush logs.
In previous versions, there used to be an option that you had to check in order to flush the logs but I don't see that available in v12.5. When I run a FULL backup of SQL, the backup completes successfully but the logs are not flushing. So I set up another template within the same policy to backup the T-LOG's, which runs (by rule) after the FULL backup completes but doesn't truncate the T-LOG either. And I had forgotten to exclude the master DB, so it gave me the error of:
"The job failed with the following error: The SQL Server master database does not support log backups. Only full backups can be performed on the master database."
Even though I got the error, the amount of the backup was the same size that SQL reports the T-LOG as being (the T-LOG is 40GB and the T-LOG backup was 40GB). So I decided to try again and excluded the MASTER DB from the selection list and ran the FULL backup again, which when complete launched the T-LOG backup, but the T-LOG backup size this time was only about 33MB, and I got an error of:
"A log backup was attempted on a database that is not currently configured to support log backups. To change the configuration use Enterprise Manager to set the recovery mode to FULL in SQL 2000 or turn off the 'trunc on chkpt' option in SQL 7. A new full backup should be performed if these settings are changed before a log backup is run."
The recovery model is set to FULL in SQL and yet I am receiving this error, so I don't know what I am missing. Any assistance or direction would be appreciated.