Forum Discussion

Z0idberg's avatar
Z0idberg
Level 2
9 years ago

Incorrect function

Hi Guys

Im having a problem doing a full vm backup to tape. The job continuously fails with Incorrect function.

JobLog.png

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?

BEJob.png

 

 

15
Backup and Recovery
Backup Exec
  • pkh's avatar
    pkh
    9 years ago

    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?

  • VJware's avatar
    VJware
    9 years ago

    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

     

  • CraigV's avatar
    CraigV
    Moderator
    9 years ago

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

    Thanks!

  • Z0idberg's avatar
    Z0idberg
    Level 2
    9 years ago

    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's avatar
    CraigV
    Moderator
    9 years ago

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

    Thanks!

  • pkh's avatar
    pkh
    Moderator
    9 years ago

    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?

  • VJware's avatar
    VJware
    Level 6
    9 years ago

    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

     

  • Z0idberg's avatar
    Z0idberg
    Level 2
    9 years ago

    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