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.
Discussion Filed Under:
Comments 6 Comments • Jump to latest comment
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
We're using Automatic backup, selecting Application does un-grey the multiple copies option.
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.
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
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?
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
Would you like to reply?
Login or Register to post your comment.