Stop Backup Exec Truncating Transaction Log File

[Polar05]

Hello,

Is there anyway to stop Backup Exec 10 truncating an MS SQL 2000 transaction log file?

Thanks!

 

[SQLBill]

Nope. Why would you want to do that? If you backup the transaction log, then the info isn't needed and it can be truncated. Now, if you are doing BOTH SQL Server backups AND Veritas backups of SQL Server - that is a BAD thing.

Take one db as an example:
MyDB
Full Backup - SQL Server
Full Backup - Veritas
TransLog Backup - SQL Server
Translog Backup - Veritas

Now you need to restore......guess what? None of the TransLog backups can be restored to the SQL Server Full Backup. You need to restore these:
Full Backup - Veritas
TransLog Backup - SQL Server
Translog Backup - Veritas

I never use Veritas to backup my SQL Server databases. I use the native SQL Server backup commands to backup to disk and then use Veritas to 'copy' the backup files to tape.

-SQLBill

Posting advice: FAQ481-4875