March 19, 2003 at 10:17 am
Has anyone had any problems with Veritas back up agent for SQL Server (either the latest version 9 or any of the previous versions)?
Thanks in advance,
John
March 19, 2003 at 10:40 am
Are you having troubles?
March 19, 2003 at 11:58 am
YES! I have Veritas Backup Exec 8.6 and found a HUGE problem with it and the SQL Agent...
If you meet these four conditions, BE 8.6 SQL Agent WILL NOT WORK unless you have the proper build (version) and HOTFIX.
-- SQL and Backup Exec were installed on multi-processor servers.
-- SQL was installed as a cluster aware application.
-- Backup Exec was installed either as a cluster aware application or on an individual node on the cluster (a non-cluster aware installation).
-- SQL and Backup Exec were both active on the same node at the same time the backup was performed.
You MUST have BE 8.6 Build (version) 3878 and HOTFIX 4 applied. If you don't have that Build and HOTFIX applied, you can backup all you want, but you can NEVER restore your database if you are using the SQL Agent.
Neither Veritas nor the third-party vendor told us about this, even though they knew about it BEFORE we bought the product. I do not have a test platform and management would not allow me to take down the production system to test a restore. Guess what happened? Yep, we had a crash and the tapes were worthless. I had to send my latest backup to VERITAS for recovery. It takes a while and they will only do it for mission critical data. Luckily the third-party vendor paid for the recovery.
I now refuse to use the SQL Agent and use the native SQL Server backup commands. Then I use BE to copy those backup files to tape. And I did convince management to allow me to test a restore.
-SQLBill
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply