cancel
Showing results for 
Search instead for 
Did you mean: 

MS-SQL-Server DB Backup to disk and tapes

faulty
Level 3

Hi,

Currently we're backing up MS-SQL-Server DB to disk, using NetBackup Enterprise 7.1 with MSSQL Agent. Now we would like to add tapes as an 2nd copy to our weekly backup like other file type backup, but we see that the options is greyed out. We're wondering if there's something we missed? We prefer not to run the the BD backup twice. Any suggestion?

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Level 6
Partner    VIP    Accredited Certified

Correct - config multiple copies on "Default-Application-Backup" schedule.

View solution in original post

6 REPLIES 6

Marianne
Level 6
Partner    VIP    Accredited Certified

In which schedule is the option greyed out? 
Automatic or Application Backup schedule?
(I don't have access to an installation right now to double-check).

Actual backup runs against Application Backup schedule, so you should be able to config multiple copies for this schedule.

faulty
Level 3

We're using Automatic backup, selecting Application does un-grey the multiple copies option.

faulty
Level 3

But according to the documentation, Application Backup can't starts by NetBackup automatically, which is what we needed, and we can't trigger manual backup too if we configured it as Application Backup.

Marianne
Level 6
Partner    VIP    Accredited Certified
Automatic schedule is used for scheduling only. Application schedule is performing actual backup (writing data) and determining retention. You can confirm by looking at previous successful backups in Activity Monitor and Client Backups report.

faulty
Level 3

Yes, we just realized that. In that case we should be configuring multiple copies on "Default-Application-Backup" and keep our scheduled backup at Automatic backup?

Marianne
Level 6
Partner    VIP    Accredited Certified

Correct - config multiple copies on "Default-Application-Backup" schedule.