Forum Discussion

Rob_Dullaart's avatar
Rob_Dullaart
Level 5
9 years ago

MSSQL policy

Hello, 

NBU Version is 7.6.0.4 on Windows 2008R2, the MSSQL database is on a Windows 2012R2

Question about an MSSQL backup. Is it possible to do a full databasebackup and do transaction-log backups with one policy or do I need to make multiple policies.

Because one can only fill in one script in the filelist of the policy. 

Regards,

Rob

7.6
Backup and Recovery
NetBackup
Windows Server (2003-2008)
  • Marianne's avatar
    Marianne
    9 years ago

    Backup Selection (script name) is not linked to a schedule - it is linked to a Policy and applies to all schedules in the policy.

    If you want DB backups and Log backups to run at different times, you need to create separate policies.

  • Marianne's avatar
    Marianne
    Level 6
    9 years ago
    The script can have transaction log backup at the end of the script after database backup section. Please note that only db's in Full recovery mode can be included in log backups, so, $all won't work.
  • Rob_Dullaart's avatar
    Rob_Dullaart
    Level 5
    9 years ago

    Thank you Marianne. 

    What if we want to make a backup of only the transaction logs in one schedule and in another schedule a full database backup. 

    We do a full database backup once a day and we want to do a separate transactionlog backup once an hour. Until now I can only think of making two separate policies for this. I am looking for a way to do this in one policy. 

  • Marianne's avatar
    Marianne
    Level 6
    9 years ago

    Backup Selection (script name) is not linked to a schedule - it is linked to a Policy and applies to all schedules in the policy.

    If you want DB backups and Log backups to run at different times, you need to create separate policies.