NetBackup 7 - How to avoid backing up specific files types like *.LDF

[Kwinter]

Hello,

We have many Window SQL servers at our location, and our DB Admin wants everything backed up with the exception of the following file types:

*.MDF

*.NDF

*.LDF

We are running NetBackup 7.0.1.  How do you globally avoid backing up these type of files.  I looked at the individual client properties, and it appears that you must put in an explicit location to avoid or exclude.

Thank you,

--Keith

[Andy_Welburn · Accepted solution]

Just use the wildcards that you mention in your "exclude list" (on each client), it should exclude them wherever they are.

No paths necessary, but it will have to be done on a per client basis (there is an Idea somewhere for global excludes)

***EDIT***

https://www-secure.symantec.com/connect/idea/global-exclude-list

and the quoted

https://www-secure.symantec.com/connect/idea/centralized-excludeinclude-manager-master-attachthis-lists-netbackup-clients-attributes

Both are "In Review" but it wouldn't hurt to vote for them!

***EDIT #2***

Just to clarify my first point, this is from the Admin Guide:

To exclude all files with a given name, regardless of their directory path, enter
the name. For example:
test
rather than
C:\test
This example is equivalent to prefixing the file pattern with
\
\*\
\*\*\
\*\*\*\
and so on.

So, for "test" read "*.ldf" etc etc

[Kwinter]

Hi Andy,

Thank you -  I'm testing it out now.  I'll update in 1hr.

--Keith

[Kwinter]

Hi Andy, 

Get this, it works on all our SQL servers that a in a stand alone environment, but we do have a few Active/Passive Microsoft Server Clusters.

I backup the members in one policy, then I created a policy with the NetBios name of the cluster and on that "clustered NetBios client" I have placed in the exclusions: 

*.MDF

*.NDF

*.LDF

but, when I check, NetBackup is backing up these files -- only for these clusters.  Very odd.  Have you seen anything like this?

Thanks,

Keith