Video Screencast Help

MS-SQL-Server DB Backup to disk and tapes

Created: 27 Nov 2012 • Updated: 28 Nov 2012 | 6 comments
This issue has been solved. See solution.

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.

Comments 6 CommentsJump to latest comment

Marianne's picture

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.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

faulty's picture

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

faulty's picture

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's picture

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.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

faulty's picture

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's picture

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

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

SOLUTION