02-08-2016 12:16 PM
Hi Guys
Im having a problem doing a full vm backup to tape. The job continuously fails with Incorrect function.
Ive reviewed the job settings and found that browsing to the SQL database also displays incorrect function and prompts a browse failure. There appears to be little information regarding this issue
Any ideas?
Solved! Go to Solution.
02-08-2016 06:12 PM
Since you are doing a full VM backup rather than the SQL database alone, you should turn on AOF.
As directed by the error message, did you look at the Windows Eventlog to see what error messages are there pertaining to the error.
You should access the SQL database using SQL Studio and use DBCC to check the integrity of the database.
Also, does your BESA has full access to the database and is given the rights as a db_owner?
02-08-2016 10:56 PM
Since you are unable to browse the SQL instance, would recommend to look at permissions first. Unchecking or checking AOFO does not make any difference now, since the failure appears in the backup selections itself.
Check the following -
1) Remote connections to the SQL instance i.e. Named Pipes & TCP/IP are enabled.
2) Does the BE account have SQL specific permissions such as sysadmin, db_owner ?
3) Is the Remote Agent on the SQL server the same version as that of the BE media server ?
4) Lastly check this KB as well - https://www.veritas.com/support/en_US/article.000030420
02-08-2016 12:28 PM
...have you turned on Advanced Open File Option for the job? If you have, turn it off and try the backup again.
Thanks!
02-08-2016 01:02 PM
Hi thank you for your response.
Being fairly new to BU Exec can you please clarify whether you suggest changes the provider or disable the Snapshot technology entirely?
Kind regards
02-08-2016 01:34 PM
Don't use Advanced Open File Option when backing up databases like Exchange. Try without AOFO and see if this fixes it.
Thanks!
02-08-2016 06:12 PM
Since you are doing a full VM backup rather than the SQL database alone, you should turn on AOF.
As directed by the error message, did you look at the Windows Eventlog to see what error messages are there pertaining to the error.
You should access the SQL database using SQL Studio and use DBCC to check the integrity of the database.
Also, does your BESA has full access to the database and is given the rights as a db_owner?
02-08-2016 10:56 PM
Since you are unable to browse the SQL instance, would recommend to look at permissions first. Unchecking or checking AOFO does not make any difference now, since the failure appears in the backup selections itself.
Check the following -
1) Remote connections to the SQL instance i.e. Named Pipes & TCP/IP are enabled.
2) Does the BE account have SQL specific permissions such as sysadmin, db_owner ?
3) Is the Remote Agent on the SQL server the same version as that of the BE media server ?
4) Lastly check this KB as well - https://www.veritas.com/support/en_US/article.000030420
02-10-2016 02:30 AM
Thanks Guys
Ive added the granted the BE account sysadmin to the SQL instance and confirmed i can now browse the instance in the Job without error. Ive began the backup and am optimistic it will complete