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 stat...
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.