SQL Backup with different policy type
Currently, We are taking backup of SQL database in flat file (backup of .bkp file) using NetBackup 7.7.3. We are thinking about changing it from flat file backup to application backup using NetBackup SQL policy. Which is better in both if we compare it on behalf of bandwidth, security, restoration, bandwidth utilization and other parameters? In current sitution this backup of this policy takes approximately 16 hr to finish. Will it improve after changing the policy and minimize the backup time?
