Forum Discussion

Andrea_Francesc's avatar
Andrea_Francesc
Level 3
10 years ago

SQLServer Automatic and Application Backup issue

Hello guys, now I have a MSSQL policy configured as Full backup (Automatic Backup) running daily based on frequency: for every day I have different Application Backup (because they use different v...
Agent for Microsoft SQL Server
Backing Up
Backup and Recovery
Configuring
NetBackup
Windows Server (2003-2008)
  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    10 years ago

    Hi,

     

    You can have multiple automatic schedules along with multiple application schedules. NetBackup will run through the application schedules in alphabetical order (if i recall correctly) and when it finds one with an open windows then it uses it. So you need to have many application schedules which are only open on certain days. i think that is what you're doing now by the sound of it.

     

    So you can add one more auto schedule and it should use the same logic.

Marianne's avatar
Marianne
Level 6
10 years ago

In support of Riaan's excellent post, herewith TN that explains how multiple schedules can be used in the same policy.

http://www.symantec.com/docs/TECH90544 
DOCUMENTATION: How to create a single MS-SQL-Server NetBackup policy which contains multiple schedules with different retention levels

 

You may also want to add your vote to this idea: 
https://www-secure.symantec.com/connect/idea/how-create-single-ms-sql-server-netbackup-policy-which-contains-multiple-schedules-different-re