Fred,

The Data Protection for SQL User's Guide has a good
explanation of how to set management classes for
individual SQL Server databases. Take a look there,
if you have additional questions, let me know.

Thanks,

Del

----------------------------------------------------

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 03/07/2007
01:08:58 PM:

> We have a number of machines running MSSQL that have multiple
> DBs which are currently backed up with a single management
> class.  Now, the owner would like different retention periods
> for selected DBs.  Considering the possible number of
> keystrokes that may be involved, can some of this be done
> thru an optionset, which could include some standards such as
>
>     include objectname\master  mgmtc
>     include objectname\model   mgmtc
>     etc
>
> Do the regular rules apply to the option file?  That would
> look something like
>
>     include * default
>     include objectname   mgmtc1
>     include objectname2  mgmtc2
>     etc.
>
> Or does someone have to enter each individual object?
>
>
> Fred Johanson