BethellGroup
asked on
Remote SQL backup failing in Backup exec; SQLVDI error in application logs
Cannot get Backup Exec 11d to successfully backup any db's on remote SQL server 2005 instance.
specifics:
backup works fine from within management console on the sql server box when backing up locally.
sql server agent installed/reinstalled correctly on Backup exec server, selection can browse db's.
other sql backups (sql 2000) on another server work OK
other non SQL backup jobs can write to media.
error details:
Backup exec reports the following error (for each db in selection):
"V-79-57344-33938 - Write on "Training_00__810ffe3a_78f
and the following exception:
The item <backup server FQDN name>\Training in use - skipped.
On the SQL box the following Application log error (in this order, at same time):
event id 1, source SQLVDI:
"SQLVDI: Loc=CVDS::GetConfiguration
. Process=6040. Thread=7224. Client. Instance=. VD=Global\Training_00__810
event id 1, source SQLVDI:
"SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=6040. Thread=7224. Client. Instance=. VD=Global\Training_00__810
there is then an error within the SQL server log, duplicated in the Application log:
Error: 3041, Severity: 16, State: 1.
Message
"BACKUP failed to complete the command BACKUP DATABASE Training. Check the backup application log for detailed messages."
The initial error points to an access denied error, but the resource credentials used are domain admin and test OK. The problem seems to be with SQLVDI; virtual device interface, but i am unsure how to troubleshoot this, I cannot find anything on the internet with the specific "ErrorCode=(5)Access is denied" error for SQLVDI
thanks
specifics:
backup works fine from within management console on the sql server box when backing up locally.
sql server agent installed/reinstalled correctly on Backup exec server, selection can browse db's.
other sql backups (sql 2000) on another server work OK
other non SQL backup jobs can write to media.
error details:
Backup exec reports the following error (for each db in selection):
"V-79-57344-33938 - Write on "Training_00__810ffe3a_78f
and the following exception:
The item <backup server FQDN name>\Training in use - skipped.
On the SQL box the following Application log error (in this order, at same time):
event id 1, source SQLVDI:
"SQLVDI: Loc=CVDS::GetConfiguration
. Process=6040. Thread=7224. Client. Instance=. VD=Global\Training_00__810
event id 1, source SQLVDI:
"SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=6040. Thread=7224. Client. Instance=. VD=Global\Training_00__810
there is then an error within the SQL server log, duplicated in the Application log:
Error: 3041, Severity: 16, State: 1.
Message
"BACKUP failed to complete the command BACKUP DATABASE Training. Check the backup application log for detailed messages."
The initial error points to an access denied error, but the resource credentials used are domain admin and test OK. The problem seems to be with SQLVDI; virtual device interface, but i am unsure how to troubleshoot this, I cannot find anything on the internet with the specific "ErrorCode=(5)Access is denied" error for SQLVDI
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I had come across the hotfix you refer, but had decided against trying it as the error code within the event description is different:
"...ErrorCode=(288)Attempt
and the article advises to only use the hotfix for that specific issue. Maybe it is still worth a shot.
As far as AOFO, i have been running the SQL job as a test job on its own since the start of my troubleshooting. Also can confirm there are no other backups running from SQL server box
"...ErrorCode=(288)Attempt
and the article advises to only use the hotfix for that specific issue. Maybe it is still worth a shot.
As far as AOFO, i have been running the SQL job as a test job on its own since the start of my troubleshooting. Also can confirm there are no other backups running from SQL server box
Just to be sure about AOFO. Even though SQL is backed up on its own, you could still have "Use Advanced Open File Option" checked. Make sure it's not checked.
I agree that the hotfix is not a good match. Maybe still worth a try - but you should probably test it first on a test system.
Maybe you could try to create a new account, make it a SQL sysadmin and a domain admin. Then use it to back up via Backup Exec. Just in case there's something funky going on with your current account.
Anything else you can see in the ERRORLOG file for SQL at the time of the errors?
I agree that the hotfix is not a good match. Maybe still worth a try - but you should probably test it first on a test system.
Maybe you could try to create a new account, make it a SQL sysadmin and a domain admin. Then use it to back up via Backup Exec. Just in case there's something funky going on with your current account.
Anything else you can see in the ERRORLOG file for SQL at the time of the errors?
Forced accept.
Computer101
EE Admin
Computer101
EE Admin
ASKER
The problem I am having is using Backup exec to back up a remote SQL server in conjunction with there own SQL agent....this is obviously a supported configuration