BE SQL Selection Logic syntax - what do each of these approaches give me?

[David_Palmersto]

I'm trying to understand the syntax of the SQL selection strings in BE

1) We are using BE 2010
2) This is for SQL 2008, production databases with Recovery Model = FULL

(I'm not sure the above really matters, but jic)

Basically, I'd like to know what parts of SQL actually get selected when I use each of the following approaches:

1) Selected Databases first, then Filegroups.
 
ServerName
 Microsoft SQL Server\Stor_sys
 Microsoft SQL Server\Stor_app
 Microsoft SQL Server\Stor_sys\*.* /SUBDIR
 Microsoft SQL Server\Stor_app\*.* /SUBDIR
 
2) Selected Databases

ServerName\Stor_app
ServerName\Stor_sys

3) Selected Filegroups

ServerName\Stor_app\*.* /SUBDIR
ServerName\Stor_sys\*.* /SUBDIR

Databases show selected, but only (2) *.* entries

4) Selected Filegroups - deselected Databases

ServerName\Stor_app\*.* /SUBDIR
ServerName\Stor_sys\*.* /SUBDIR
ServerName\Stor_app /EXCLUDE
ServerName\Stor_sys /EXCLUDE

We've got our multi-level policy setup, but want to make sure that each backup is catching the right kind of resources for our restores.

Thanks,
 

[David_Palmersto]

Sorry, forgot to add the cases:

A) In a FULL Backup

B) In a LOG Backup

Because I believe that many of the results will be different in a FULL vs. LOG Backup style..

Thanks again.