Backup Exec 2010 R2 - MS SQL Backups
Posted on 2010-11-11
I am currently using Backup Exec 2010 R2 to backup all of our servers.
I have created a selection list that includes all servers that have an instance
of Microsoft SQL installed on them and have selected all the LIVE databases to be backed up.
The majority of our databases are set to have recovery model of FULL as do not understand why you would want to use "simple" on production servers. Therefore I have created a Job Policy with two templates:
a). Full - Back up entire database or file group
If template "a" successfully completes run "b"
b). Log - Back up transaction log (need to run this to truncate the logs)
However, the problem I have is that template "b" compeltes with exceptions. The exceptions are that the "master" database only excepts "full" backups and "log" backups cannot be performed.
Am I able to exclude the masterlog.ldf from template "b"?
When I created my SQL Selection list I drilled down to the servers name and then selected "Microsoft SQL Server" and ticked the appropriate databases to be backed up. It did not show the log files here and I MUST backup the master database.
Thanks for your time and hope this can be resolved...