You could use 3 policies, depending on your requirements, with calendar 
based schedules.  For example, 1 policy might be weekly and specify all 
Saturdays of a month except for the first (and manually exclude dates in 
future years that will have the yearly backup). The 2nd policy might be 
monthly and specify only the 1st Saturday of each month (again manually 
excluding future dates of the yearly backups).  The 3rd policy might be 
the yearly and would specify the specific dates for the future yearly 
backups.   I'm not recommending this!  Only suggesting it's possible.

Michael F. Lavelle, in his post of 11/18/2005 11:22 AM, has given us the 
definitive explanation of agent backups and how to use multiple 
retention periods.  Highly recommended reading!

cheers, wayne

Austin Murphy wrote, in part,  on 1/19/2006 10:23 AM:
> Does anyone have any insight on how to do scheduled
> weekly/monthly/yearly backups (with commensurate retention periods) of
> an MSSQL or Oracle database with Netbackup?
>
> I am running 5.1 MP3 on Solaris 9 and just found out that the database
> policy schedules don't work the same way as the file policy schedules.
>
> It has been pointed out to me that I could setup 3 Policies for
> weekly/monthly/yearly backups, but this won't stop the weekly when a
> monthly runs.  Nor will the monthly (or weekly) be suspended when the
> yearly is run.
>