Backing up SQL Transaction Problems

[ajcc22]

HI

We are running Backup exec 2010 R3, we have several servers running SQL 2008 being backed up with the SQL agent.

We do a full backup of the SQL DB’s and constantly get the errors:

V-79-40960-37914 - Database ReportServer 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.

Ok, so we created a job that just did the Transaction logs by setting the Microsoft SQL tab to “Log- Back up transaction log” and this created the following errors:

V-79-57344-33960 - A log backup was attempted on database iSAMS that is not configured to support log backups.
To change the configuration, use the SQL administration tools to set the recovery mode to Full.
A new full backup should be performed if this setting is changed before a log backup is run.

V-79-57344-33959 - The master database only supports full backups.
Differential and log backups cannot be performed on the master database.

What am I doing wrong?

Alan.

[ZeRoC00L]

Check this technote for some more info:

http://www.symantec.com/business/support/index?page=content&id=TECH126063

Maybe some of your databases are configured with Recovery Model of "Full" and some with "Simple" ?

[pkh]

You cannot just use the same selection list to do your log backups because databases like the Master does not maintain logs so you cannot do log backups on them.  What you need to do is to look at the errors in your log backup job and create a selection which excludes those databases which give an error during the log backup.

[ajcc22]

Many thanks, ill give it a go.

alan.