November 1, 2004 at 8:20 am
Hi,
What is the best strategy for backing up my SQL data to tape using Veritas?
a) Backup the transaction logs
b) Use the Veritas sql agent to backup the data directly
Thank you, Victor...
November 2, 2004 at 6:58 am
If your network admins allow it, it probably would be best to use Veritas for both database and transaction log backups. That way, when restoring from Veritas, the backup sets would be logically grouped and you could restored them together.
In our location, the network admins decided that they didn't want to use Veritas to backup the transaction logs directly because it would tie up the tape drives during the day (we use Veritas to backup all other data on the network servers). The compromise we came to was to use Veritas for full database backups nightly and let SQL Server backup the transaction logs, then use Veritas to backup the log files during the nightly process. We tested to make sure we could do a restore using a full backup from Veritas and then apply the transaction log backups done by SQL. It does work, although I do admit it's a little clunky.
November 3, 2004 at 8:59 am
I backup my SQL Server databases (and logs) to hard drive and then use Veritas to copy those backup files to tape.
-SQLBill
June 7, 2006 at 9:14 am
Same here
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply