cancel
Showing results for 
Search instead for 
Did you mean: 

status = 2: none of the requested files were backed up && ms-sql server does not start automatically

billel_kebadji
Level 3

I had a problem.

status = 2: none of the requested files were backed up

after the resolution of the problem as follows:

https://support.symantec.com/en_US/article.TECH31961.html

I found a new problem, the policy ms-sql server does not start automatically, even if there is no back up in court

but if I execute manually works.

I use Windows server 2012 standard. and symantec netbackup 7.6

Thank you

 

 

 

 

5 REPLIES 5

RiaanBadenhorst
Level 6
Partner    VIP    Accredited Certified

What does the schedule look like ? Frequency of Calendar? If its frequency (say 1 day) then it will only run 1 day aftter you ran it manually. Say it was supposed to run at 8pm last night, didn't work, you then run it today at 8am, it works. Tonight it wont run at 8pm because it has run within 1 day (8am) . If you leave it be, tomorrow night at 8pm it will run as it would have been 1.5 days since it ran.

Marianne
Level 6
Partner    VIP    Accredited Certified
Is policy schedule Frequency or Calendar based? If Frequency, then a manual backup will 'disturb ' the Frequency. If schedule is set to everyone 1 day, then it means 24 hours must elapse since previous successful backup. You will need to change Frequency to a number of hours to get the schedule back in 'sync'. If Calendar, please show us your policy config : bppllist ( policy-name ) -U

billel_kebadji
Level 3

        No specific exclude dates entered
        No exclude days of week entered
    PFI Recovery:        0
    Maximum MPX:         1
    Retention Level:     9 (infinity)
    Residence is Storage Lifecycle Policy:         0
    Schedule indexing:   0
    Daily Windows:
          Sunday     09:05:00  -->  Sunday     10:00:00
          Monday     09:05:00  -->  Monday     10:00:00
          Tuesday    09:05:00  -->  Tuesday    10:00:00
          Wednesday  09:05:00  -->  Wednesday  10:00:00
          Thursday   09:05:00  -->  Thursday   10:00:00
          Friday     09:05:00  -->  Friday     10:00:00
          Saturday   09:05:00  -->  Saturday   10:00:00

  Schedule:              AXProd-FullDiff-At10h
    Type:                Automatic Backup
    Frequency:           every 1 hour
     Excluded Dates----------
        No specific exclude dates entered
        No exclude days of week entered
    PFI Recovery:        0
    Maximum MPX:         1
    Retention Level:     9 (infinity)
    Residence is Storage Lifecycle Policy:         0
    Schedule indexing:   0
    Daily Windows:
          Sunday     10:05:00  -->  Sunday     11:00:00
          Monday     10:05:00  -->  Monday     11:00:00
          Tuesday    10:05:00  -->  Tuesday    11:00:00
          Wednesday  10:05:00  -->  Wednesday  11:00:00
          Thursday   10:05:00  -->  Thursday   11:00:00
          Friday     10:05:00  -->  Friday     11:00:00
          Saturday   10:05:00  -->  Saturday   11:00:00

  Schedule:              AXProd-FullDiff-At11h
    Type:                Automatic Backup
    Frequency:           every 1 hour
     Excluded Dates----------
        No specific exclude dates entered
        No exclude days of week entered
    PFI Recovery:        0
    Maximum MPX:         1
    Retention Level:     9 (infinity)
    Residence is Storage Lifecycle Policy:         0
    Schedule indexing:   0
    Daily Windows:
          Sunday     11:05:00  -->  Sunday     12:00:00
          Monday     11:05:00  -->  Monday     12:00:00
          Tuesday    11:05:00  -->  Tuesday    12:00:00
          Wednesday  11:05:00  -->  Wednesday  12:00:00
          Thursday   11:05:00  -->  Thursday   12:00:00
          Friday     11:05:00  -->  Friday     12:00:00
          Saturday   11:05:00  -->  Saturday   12:00:00

  Schedule:              AXProd-FullDiff-At13h
    Type:                Automatic Backup
    Frequency:           every 1 hour
     Excluded Dates----------
        No specific exclude dates entered
        No exclude days of week entered
    PFI Recovery:        0
    Maximum MPX:         1
    Retention Level:     9 (infinity)
    Residence is Storage Lifecycle Policy:         0
    Schedule indexing:   0
    Daily Windows:
          Sunday     13:05:00  -->  Sunday     14:00:00
          Monday     13:05:00  -->  Monday     14:00:00
          Tuesday    13:05:00  -->  Tuesday    14:00:00
          Wednesday  13:05:00  -->  Wednesday  14:00:00
          Thursday   13:05:00  -->  Thursday   14:00:00
          Friday     13:05:00  -->  Friday     14:00:00
          Saturday   13:05:00  -->  Saturday   14:00:00

  Schedule:              AXProd-FullDiff-At14h
    Type:                Automatic Backup
    Frequency:           every 1 hour
     Excluded Dates----------
        No specific exclude dates entered
        No exclude days of week entered
    PFI Recovery:        0
    Maximum MPX:         1
    Retention Level:     9 (infinity)
    Residence is Storage Lifecycle Policy:         0
    Schedule indexing:   0
    Daily Windows:
          Sunday     14:05:00  -->  Sunday     15:00:00
          Monday     14:05:00  -->  Monday     15:00:00
          Tuesday    14:05:00  -->  Tuesday    15:00:00
          Wednesday  14:05:00  -->  Wednesday  15:00:00
          Thursday   14:05:00  -->  Thursday   15:00:00
          Friday     14:05:00  -->  Friday     15:00:00
          Saturday   14:05:00  -->  Saturday   15:00:00

  Schedule:              AXProd-FullDiff-At15h
    Type:                Automatic Backup
    Frequency:           every 1 hour
     Excluded Dates----------
        No specific exclude dates entered
        No exclude days of week entered
    PFI Recovery:        0
    Maximum MPX:         1
    Retention Level:     9 (infinity)
    Residence is Storage Lifecycle Policy:         0
    Schedule indexing:   0
    Daily Windows:
          Sunday     15:05:00  -->  Sunday     16:00:00
          Monday     15:05:00  -->  Monday     16:00:00
          Tuesday    15:05:00  -->  Tuesday    16:00:00
          Wednesday  15:05:00  -->  Wednesday  16:00:00
          Thursday   15:05:00  -->  Thursday   16:00:00
          Friday     15:05:00  -->  Friday     16:00:00
          Saturday   15:05:00  -->  Saturday   16:00:00

  Schedule:              AXProd-FullDiff-At16h
    Type:                Automatic Backup
    Frequency:           every 1 hour
     Excluded Dates----------
        No specific exclude dates entered
        No exclude days of week entered
    PFI Recovery:        0
    Maximum MPX:         1
    Retention Level:     9 (infinity)
    Residence is Storage Lifecycle Policy:         0
    Schedule indexing:   0
    Daily Windows:
          Sunday     16:05:00  -->  Sunday     17:00:00
          Monday     16:05:00  -->  Monday     17:00:00
          Tuesday    16:05:00  -->  Tuesday    17:00:00
          Wednesday  16:05:00  -->  Wednesday  17:00:00
          Thursday   16:05:00  -->  Thursday   17:00:00
          Friday     16:05:00  -->  Friday     17:00:00
          Saturday   16:05:00  -->  Saturday   17:00:00

  Schedule:              AXProd-FullDiff-At17h
    Type:                Automatic Backup
    Frequency:           every 1 hour
     Excluded Dates----------
        No specific exclude dates entered
        No exclude days of week entered
    PFI Recovery:        0
    Maximum MPX:         1
    Retention Level:     9 (infinity)
    Residence is Storage Lifecycle Policy:         0
    Schedule indexing:   0
    Daily Windows:
          Sunday     17:05:00  -->  Sunday     18:00:00
          Monday     17:05:00  -->  Monday     18:00:00
          Tuesday    17:05:00  -->  Tuesday    18:00:00
          Wednesday  17:05:00  -->  Wednesday  18:00:00
          Thursday   17:05:00  -->  Thursday   18:00:00
          Friday     17:05:00  -->  Friday     18:00:00
          Saturday   17:05:00  -->  Saturday   18:00:00

  Schedule:              AXProd-FullDiff-At18h
    Type:                Automatic Backup
    Frequency:           every 1 hour
     Excluded Dates----------
        No specific exclude dates entered
        No exclude days of week entered
    PFI Recovery:        0
    Maximum MPX:         1
    Retention Level:     9 (infinity)
    Residence is Storage Lifecycle Policy:         0
    Schedule indexing:   0
    Daily Windows:
          Sunday     18:05:00  -->  Sunday     19:00:00
          Monday     18:05:00  -->  Monday     19:00:00
          Tuesday    18:05:00  -->  Tuesday    19:00:00
          Wednesday  18:05:00  -->  Wednesday  19:00:00
          Thursday   18:05:00  -->  Thursday   19:00:00
          Friday     18:05:00  -->  Friday     19:00:00
          Saturday   18:05:00  -->  Saturday   19:00:00

  Schedule:              AXProd-FullDiff-At19h
    Type:                Automatic Backup
    Frequency:           every 1 hour
     Excluded Dates----------
        No specific exclude dates entered
        No exclude days of week entered
    PFI Recovery:        0
    Maximum MPX:         1
    Retention Level:     9 (infinity)
    Residence is Storage Lifecycle Policy:         0
    Schedule indexing:   0
    Daily Windows:
          Sunday     19:05:00  -->  Sunday     20:00:00
          Monday     19:05:00  -->  Monday     20:00:00
          Tuesday    19:05:00  -->  Tuesday    20:00:00
          Wednesday  19:05:00  -->  Wednesday  20:00:00
          Thursday   19:05:00  -->  Thursday   20:00:00
          Friday     19:05:00  -->  Friday     20:00:00
          Saturday   19:05:00  -->  Saturday   20:00:00

  Schedule:              AXProd-FullDiff-At20h
    Type:                Automatic Backup
    Frequency:           every 1 hour
     Excluded Dates----------
        No specific exclude dates entered
        No exclude days of week entered
    PFI Recovery:        0
    Maximum MPX:         1
    Retention Level:     9 (infinity)
    Residence is Storage Lifecycle Policy:         0
    Schedule indexing:   0
    Daily Windows:
          Sunday     20:05:00  -->  Sunday     21:00:00
          Monday     20:05:00  -->  Monday     21:00:00
          Tuesday    20:05:00  -->  Tuesday    21:00:00
          Wednesday  20:05:00  -->  Wednesday  21:00:00
          Thursday   20:05:00  -->  Thursday   21:00:00
          Friday     20:05:00  -->  Friday     21:00:00
          Saturday   20:05:00  -->  Saturday   21:00:00

  Schedule:              AXProd-FullDiff-At21h
    Type:                Automatic Backup
    Frequency:           every 1 hour
     Excluded Dates----------
        No specific exclude dates entered
        No exclude days of week entered
    PFI Recovery:        0
    Maximum MPX:         1
    Retention Level:     9 (infinity)
    Residence is Storage Lifecycle Policy:         0
    Schedule indexing:   0
    Daily Windows:
          Sunday     21:05:00  -->  Sunday     22:00:00
          Monday     21:05:00  -->  Monday     22:00:00
          Tuesday    21:05:00  -->  Tuesday    22:00:00
          Wednesday  21:05:00  -->  Wednesday  22:00:00
          Thursday   21:05:00  -->  Thursday   22:00:00
          Friday     21:05:00  -->  Friday     21:45:00
          Saturday   21:05:00  -->  Saturday   22:00:00

  Schedule:              AXProd-FullDiff-At22h
    Type:                Automatic Backup
    Frequency:           every 1 hour
     Excluded Dates----------
        No specific exclude dates entered
        No exclude days of week entered
    PFI Recovery:        0
    Maximum MPX:         1
    Retention Level:     9 (infinity)
    Residence is Storage Lifecycle Policy:         0
    Schedule indexing:   0
    Daily Windows:
          Sunday     22:05:00  -->  Sunday     23:00:00
          Monday     22:05:00  -->  Monday     23:00:00
          Tuesday    22:05:00  -->  Tuesday    23:00:00
          Wednesday  22:05:00  -->  Wednesday  23:00:00
          Thursday   22:05:00  -->  Thursday   23:00:00
          Saturday   22:05:00  -->  Saturday   23:00:00

  Schedule:              AXProd-FullDiff-At23h
    Type:                Automatic Backup
    Frequency:           every 1 hour
     Excluded Dates----------
        No specific exclude dates entered
        No exclude days of week entered
    PFI Recovery:        0
    Maximum MPX:         1
    Retention Level:     9 (infinity)
    Residence is Storage Lifecycle Policy:         0
    Schedule indexing:   0
    Daily Windows:
          Sunday     23:05:00  -->  Sunday     24:00:00
          Monday     23:05:00  -->  Monday     24:00:00
          Tuesday    23:05:00  -->  Tuesday    24:00:00
          Wednesday  23:05:00  -->  Wednesday  24:00:00
          Thursday   23:05:00  -->  Thursday   24:00:00
          Saturday   23:05:00  -->  Saturday   24:00:00

  Schedule:              Default-Application-Backup
    Type:                Application Backup
     Excluded Dates----------
        No specific exclude dates entered
        No exclude days of week entered
    PFI Recovery:        0
    Maximum MPX:         1
    Retention Level:     0 (1 week) 0 (1 week)
    Number Copies:       2
    Fail on Error:       0 0
    Residence:           FDriveStorageUnit alg-netbackup-hcart
    Volume Pool:         NetBackup NetBackup
    Server Group:        *ANY* *ANY*
    Residence is Storage Lifecycle Policy:         0
    Schedule indexing:   0
    Daily Windows:
          Sunday     00:00:00  -->  Sunday     24:00:00
          Monday     00:00:00  -->  Monday     24:00:00
          Tuesday    00:00:00  -->  Tuesday    24:00:00
          Wednesday  00:00:00  -->  Wednesday  24:00:00
          Thursday   00:00:00  -->  Thursday   24:00:00
          Friday     00:00:00  -->  Friday     24:00:00
          Saturday   00:00:00  -->  Saturday   24:00:00


is not frequency problem !!

Marianne
Level 6
Partner    VIP    Accredited Certified

I have experienced similar issues where hourly backups got 'broken' after a failed backup.
For some reason the schedule will be ignore until the global setting of # tries every ## hours have passed (the default is 2 tries every 12 hours).

Here is an example of where I have described this behaviour: 
https://www-secure.symantec.com/connect/forums/netbackup-not-starting-fequency-based-backups#comment...  

The workaround is normally to kick off a manual backup in order to 'kick-start' the scheduler again. 

billel_kebadji
Level 3
the problem is resolved was a bug in SQL Server,.
Thank you for your support Riaan.Badenhorst and Marianne. :)