Link to home
Create AccountLog in
Avatar of spen_lang
spen_lang

asked on

Backup Exec 2010 R2 - MS SQL Backups

Hi,

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...
ASKER CERTIFIED SOLUTION
Avatar of Iamthecreator
Iamthecreator
Flag of France image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of spen_lang
spen_lang

ASKER

Am I able to exclude the msterlog.ldf from the backup as do not want to have create an extra policy to backup the master databases...