Solved: Incorrect function

Z0idberg · ‎02-08-2016

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?

pkh · ‎02-08-2016

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?

View solution in original post

VJware · ‎02-08-2016

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

View solution in original post

CraigV · ‎02-08-2016

...have you turned on Advanced Open File Option for the job? If you have, turn it off and try the backup again.

Thanks!

Z0idberg · ‎02-08-2016

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

CraigV · ‎02-08-2016

Don't use Advanced Open File Option when backing up databases like Exchange. Try without AOFO and see if this fixes it.