Forum Discussion

Hamzah's avatar
Hamzah
Level 3
11 months ago

Legacy SQL backup policy

Dears, I have a confusion regarding NetBackup for SQL using Legacy SQL Policy,   What is the correct way to backup SQL databases and Logs and truncate the logs afterwards. 1-  is it possible to i...
20
Windows Server 2016
  • Michal_Mikulik1's avatar
    Michal_Mikulik1
    11 months ago

    Hello,

    both options are possible, I preferred the second one when MSSQL intelligent policies were not yet supported. It was better for reporting and troubleshooting.

    Is there a special reason for using legacy policy? Intelligent policies are generally better .

    As for your last question, NBU does not have much control of the script content, it is almost entirely on the script author. You can have "Hello world" instruction only there and the parent backup job can end with status 0 (but not generating any child backup jobs for individual databases backups which should be suspicious of course..)

    Regards

    M.

Michal_Mikulik1's avatar
Michal_Mikulik1
Moderator
11 months ago

Hello,

both options are possible, I preferred the second one when MSSQL intelligent policies were not yet supported. It was better for reporting and troubleshooting.

Is there a special reason for using legacy policy? Intelligent policies are generally better .

As for your last question, NBU does not have much control of the script content, it is almost entirely on the script author. You can have "Hello world" instruction only there and the parent backup job can end with status 0 (but not generating any child backup jobs for individual databases backups which should be suspicious of course..)

Regards

M.