Forum Discussion

balrchin's avatar
balrchin
Level 2
7 years ago

STATUS CODE 2: Microsoft SQL backups fail with a NetBackup Status Code 2 "none of the requested file

Could some one help me resolving this issue -

 

It was backing up till yesterday and its failing since one day

(2) none of the requested files were backed up.

 

I have attached the detailed status of the job.

8
Windows 8
  • Marianne's avatar
    Marianne
    7 years ago

    balrchin

    You need to find out what has changed on the SQL client.

    Has anyone perhaps modified the script?

    Please see if there is a GROUPSIZE entry in the script:

    Feb 12, 2018 11:47:53 AM - Info dbclient (pid=8948) USER - GROUPSIZE must be between 1 and 32.
    Feb 12, 2018 11:47:55 AM - Info dbclient (pid=8948) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\FullBackupDAG.bch>:

    If this is not the issue, ensure dbclient log foilder exists on the client (under ...NetBackup\logs) and retry the backup.

    Check dbclient log for errors (or upload as dbclient.txt).

  • Marianne's avatar
    Marianne
    Level 6
    7 years ago

    balrchin

    You need to find out what has changed on the SQL client.

    Has anyone perhaps modified the script?

    Please see if there is a GROUPSIZE entry in the script:

    Feb 12, 2018 11:47:53 AM - Info dbclient (pid=8948) USER - GROUPSIZE must be between 1 and 32.
    Feb 12, 2018 11:47:55 AM - Info dbclient (pid=8948) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\FullBackupDAG.bch>:

    If this is not the issue, ensure dbclient log foilder exists on the client (under ...NetBackup\logs) and retry the backup.

    Check dbclient log for errors (or upload as dbclient.txt).

      • Marianne's avatar
        Marianne
        Level 6
        7 years ago

        I am confused about the fact that you marked the post as solved.
        Did you check the script? 
        Can you please upload it here?

        There is definitely a problem with the script as we see the following in the log:  

        CDBbackmain:: OperationsAreGroupable: INF - The batch file is not groupable because the master database is included in the grouping set.
        .....
        ReadBatch: USER - GROUPSIZE must be between 1 and 32.

        Oh! There seems to be 2 separate scripts - the log for 10 Feb shows this script name: 
        C:\Program Files\Veritas\NetBackup\DbExt\MsSql\FullBackupPhysical.bch
        and seems to indicate successful backup.

        The failure on 11 Feb shows this script name:
        C:\Program Files\Veritas\NetBackup\DbExt\MsSql\FullBackupDAG.bch 

        You need to check FullBackupDAG.bch. 
        Compare with FullBackupPhysical.bch to see what is different.