netbackup 1

[masds]

Has anybody ever used the third party backup tool NetBackup? Does it affect the SQL server backup jobs?
Thanks

 

[SQLBill]

I don't use netbackup, but make sure you don't backup the .mdf and .ldf files. If you do a netbackup of those files, they won't do you any good. You can only backup those files when they are not in use (either with SQL Server stopped or the database detached).

You can do SQL Server BACKUP commands to backup the databases to disk and then use netbackup to 'copy' those backup files. However, you must make sure that:

1. netbackup isn't trying to backup the files when SQL Server is writing to them
or
2. SQL Server isn't trying to write to the files when NetBackup is copying them.

-SQLBill

Posting advice: FAQ481-4875

 

[masds]

Thanks a lot Bill, that really helps.

 

[masds]

This is a interesting topic, I want know a little bit more.

Some third party backup tools actually has features like SQl server database backup, it sounds like the backup is taken from the database rather than a filesystem file copy. This may raise issues when there are also SQL Server scheduled backup jobs,

For example, the third party tool weekly full backup and daily differential backup, if there is a SQL Server job full backup the database every day, is the SQL Server jobs affect the daily differential backups?

 

[SQLBill]

Yes. Veritas Backup Exec with the Agent for SQL Server does that. You have to chose which one to use.

It's the same as using file backups, NetBackup, et al.

You should backup each file one way and one way only.

-SQLBill

Posting advice: FAQ481-4875