Sql-server – Using SQL Server native backup and Veritas Backup Exec to backup the database and transaction log on the same database

backupsql server

I have a customer who use the Microsoft SQL Server native backup and Veritas Backup Exec to backup the database and transaction log on the same database.

The native backup runs at 5 AM while the Veritas Backup Exec runs at 12 AM and 12 PM. Can the same database be backup by two different backup software and restored correctly?

Sorry if I have missed out some facts.

Best Answer

You can only have one backup "solution" (backup path) doing log backups. So, this is your first decision - which one.

Next question is whether you are planning to do differential backups. The backup path not doing diff backups should do their full backups using copy_only.

So, one backup path that only does full backups using copy_only so it doesn't affect the other's diff backups.

The other backup path does full, and then possibly also log and diff backups depending on your requirements.

Then you should decide how you expect to restore. Management Studio's restore dialog can be confusing in how it reads the backup history to generate the restore commands. So this is where it becomes extra important to test!