01-22-2018 11:14 PM
I am looking for Pre and Post script to the netbackup (sql agent backup using .bch) job to disable the antivirus (this means when SQL agent backup running during the xx-hours to xx-hours i don't want to run Symantec Antivirus and once backup complete sucess antivirus should enable.
Any Help, comments or Ideas are appreciated.
01-22-2018 11:50 PM
Sorry, not possible with agent backups - only MS-Windows and Standard policy types.
01-26-2018 08:57 AM
01-26-2018 09:00 AM
01-28-2018 05:07 AM
01-28-2018 04:52 PM
The reason for i want to exclude AV is some of the SQL server database(BLOB enabled ex:G\ drive) agents are taking more time than usual.
after i select exception for G:\(BLOB enabled) backup timing down hence i'm looking for pre and post script to the netbackup job to disable the antivirus i would appreciate your further advice on this matter.
01-28-2018 10:45 PM
Maybe you should ask on a Microsoft and Symantec AV forum if it is a good idea to exclude SQL data from AV scanning.
I found an old blog that could still be relevant (or not with BLOB storage), but I guess fellow SQL users may be able to give best advice.
The blog suggests that SQL data should be excluded from AV.
From a NetBackup point of view, pre- and post- scripts are not supported with agent backups.
These scripts are ignored with agent backups.
01-30-2018 04:07 AM
A few more links in support of Mariannes and the requirement or not for AV to run against the SQL Server installation.
In general, & certainly if we encounter performance issues, we ensure that SQL Server is excluded from any AV scans or on-access scanning. This is purely from a SQL Server operational point of view.