Restoring backups that finish with Status Code 1

[Wiley_Winter]

I have an issue with finding backups to restore if the status code is a 1. Status code 0, of course, will restore. I'm using NBU 5.1 MP2 on a Windows 2003 server. This occurs with regular NT backups and with SQL backups.
I do have the appropriate licenses for the SQL option.
Any clues?
Thanks,
Wiley

[zippy]

Wiley,

"1" means that a file was busy or deleted during the backup, if the SQL backup is working correctly you should not see a 1, so look at the logs and see what file it's choking on.

Jim

[Phani_Kiran]

Wiley,

Make sure that you configure a seperate policy to backup SQL databases. Here is a guide that can help you configure the SQL policy -

http://backups.lbl.gov/backups/documentation/SysAdmin/5.1/NetBackup_AdminGuide_MSSQL_Win.pdf

If you try and backup the databases as part of a regular Windows policy, you will obviously see 1s as they are locked by MS-SQL and will be skipped.

[Ankur_Kumar]

Hi Wiley,
if you are refferring to the fact that a sql backup is comming out with status code 1 or more than one database in your script was not backed up, please do check on the mssql_backup_failure log file, dbclient log file. Please do update us on your current findings.

Chiao
Ankur Kumar

[Wiley_Winter]

Thanks for your replies.
I reran the SQL backups and they ran without a hitch. I suppose this is a catalog issue. When I try to restore any of the backups, specifically weeklies and monthlies that have longer retention rates (1 month and 6 months resp), I see nothing!
Initially I thought the backups finishing with a "1" were not showing up in the restore window but that idea was dashed today!
Thanks,
Wiley

[Ankur_Kumar]

Wiley my friend,

are you using a sql agent for the restoration purpose, could you please give us the bppllist < policy name> -L for the sql policy you are loking out for restoration.

Chiao
Ankur Kumar

[Wiley_Winter]

Ankur,
It's a long listing, but here you go!
Thanks,
Wiley



Policy Name: daily_sql
Options: 0x0
template: FALSE
c_unused1: ?
Names: (none)
Policy Type: MS-SQL-Server (15)
Active: yes
Effective date: 06/21/2006 08:50:00
Mult. Data Stream: no
Perform Snapshot Backup: no
Snapshot Method: (none)
Snapshot Method Arguments: (none)
Perform Offhost Backup: no
Backup Copy: 0
Use Data Mover: no
Data Mover Type: 0
Use Alternate Client: no
Alternate Client Name: (none)
Enable Instant Recovery: no
Policy Priority: 0
Max Jobs/Policy: Unlimited
Disaster Recovery: 0
Keyword: (none specified)
Client Encrypt: no
Checkpoint: no
Residence: matcu-netbackup-dlt2-robot-tld-0
Volume Pool: Daily
Client/HW/OS/Pri: uc4 PC Windows2000 0 0 0 0 ?
Client/HW/OS/Pri: matcu-gpg201 PC WindowsNET 0 0 0 0 ?
Client/HW/OS/Pri: post-oltp PC WindowsNET 0 0 0 0 ?
Client/HW/OS/Pri: post-office PC WindowsNET 0 0 0 0 ?
Include: sqlfull.bch
Exclude: (none defined)
Schedule: Default-Application-Backup
Type: UBAK SQL Server (2)
Frequency: 7 day(s) (604800 seconds)
Maximum MPX: 6
Synthetic: 0
PFI Recovery: 0
Retention Level: 3 (1 month)
u-wind/o/d: 0 0
Incr Type: DELTA (0)
Incr Depends: (none defined)
Max Frag Size: 0 MB
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: (same as policy volume pool)
Daily Windows:
Day Open Close W-Open W-Close
Sunday 000:00:00 024:00:00 000:00:00 024:00:00
Monday 000:00:00 024:00:00 024:00:00 048:00:00
Tuesday 000:00:00 024:00:00 048:00:00 072:00:00
Wednesday 000:00:00 024:00:00 072:00:00 096:00:00
Thursday 000:00:00 024:00:00 096:00:00 120:00:00
Friday 000:00:00 024:00:00 120:00:00 144:00:00
Saturday 000:00:00 024:00:00 144:00:00 168:00:00
Schedule: Daily_SQL
Type: FULL SSQL Server (0)
Calendar sched: Enabled
SPECIFIC DATE 0 - 02/11/2006
SPECIFIC DATE 1 - 03/05/2006
SPECIFIC DATE 2 - 04/02/2006
SPECIFIC DATE 3 - 04/17/2006
SPECIFIC DATE 4 - 04/24/2006
SPECIFIC DATE 5 - 04/25/2006
SPECIFIC DATE 6 - 04/26/2006
SPECIFIC DATE 7 - 04/27/2006
SPECIFIC DATE 8 - 04/28/2006
SPECIFIC DATE 9 - 04/29/2006
SPECIFIC DATE 10 - 05/02/2006
SPECIFIC DATE 11 - 05/03/2006
SPECIFIC DATE 12 - 05/04/2006
SPECIFIC DATE 13 - 05/05/2006
SPECIFIC DATE 14 - 05/09/2006
SPECIFIC DATE 15 - 05/10/2006
SPECIFIC DATE 16 - 05/11/2006
SPECIFIC DATE 17 - 05/12/2006
SPECIFIC DATE 18 - 05/16/2006
SPECIFIC DATE 19 - 05/17/2006
SPECIFIC DATE 20 - 05/18/2006
SPECIFIC DATE 21 - 05/19/2006
SPECIFIC DATE 22 - 05/22/2006
SPECIFIC DATE 23 - 05/23/2006
SPECIFIC DATE 24 - 05/24/2006
SPECIFIC DATE 25 - 05/25/2006
SPECIFIC DATE 26 - 05/26/2006
SPECIFIC DATE 27 - 05/30/2006
SPECIFIC DATE 28 - 05/31/2006
SPECIFIC DATE 29 - 06/01/2006
SPECIFIC DATE 30 - 06/02/2006
SPECIFIC DATE 31 - 06/05/2006
SPECIFIC DATE 32 - 06/06/2006
SPECIFIC DATE 33 - 06/07/2006
SPECIFIC DATE 34 - 06/08/2006
SPECIFIC DATE 35 - 06/09/2006
SPECIFIC DATE 36 - 06/12/2006
SPECIFIC DATE 37 - 06/13/2006
SPECIFIC DATE 38 - 06/14/2006
SPECIFIC DATE 39 - 06/15/2006
SPECIFIC DATE 40 - 06/16/2006
SPECIFIC DATE 41 - 06/19/2006
SPECIFIC DATE 42 - 06/20/2006
SPECIFIC DATE 43 - 06/21/2006
SPECIFIC DATE 44 - 06/22/2006
SPECIFIC DATE 45 - 06/23/2006
SPECIFIC DATE 46 - 06/26/2006
SPECIFIC DATE 47 - 06/27/2006
SPECIFIC DATE 48 - 06/28/2006
SPECIFIC DATE 49 - 06/29/2006
SPECIFIC DATE 50 - 06/30/2006
SPECIFIC DATE 51 - 07/03/2006
SPECIFIC DATE 52 - 07/05/2006
SPECIFIC DATE 53 - 07/06/2006
SPECIFIC DATE 54 - 07/07/2006
SPECIFIC DATE 55 - 07/10/2006
SPECIFIC DATE 56 - 07/11/2006
SPECIFIC DATE 57 - 07/12/2006
SPECIFIC DATE 58 - 07/13/2006
SPECIFIC DATE 59 - 07/14/2006
SPECIFIC DATE 60 - 07/17/2006
SPECIFIC DATE 61 - 07/18/2006
SPECIFIC DATE 62 - 07/19/2006
SPECIFIC DATE 63 - 07/20/2006
SPECIFIC DATE 64 - 07/21/2006
SPECIFIC DATE 65 - 07/24/2006
SPECIFIC DATE 66 - 07/25/2006
SPECIFIC DATE 67 - 07/26/2006
SPECIFIC DATE 68 - 07/27/2006
SPECIFIC DATE 69 - 07/28/2006
SPECIFIC DATE 70 - 07/31/2006
SPECIFIC DATE 71 - 08/01/2006
SPECIFIC DATE 72 - 08/02/2006
SPECIFIC DATE 73 - 08/03/2006
SPECIFIC DATE 74 - 08/04/2006
SPECIFIC DATE 75 - 08/06/2006
SPECIFIC DATE 76 - 08/07/2006
SPECIFIC DATE 77 - 08/08/2006
SPECIFIC DATE 78 - 08/09/2006
SPECIFIC DATE 79 - 08/10/2006
SPECIFIC DATE 80 - 08/11/2006
SPECIFIC DATE 81 - 08/13/2006
SPECIFIC DATE 82 - 08/14/2006
SPECIFIC DATE 83 - 08/15/2006
SPECIFIC DATE 84 - 08/16/2006
SPECIFIC DATE 85 - 08/17/2006
SPECIFIC DATE 86 - 08/18/2006
SPECIFIC DATE 87 - 08/20/2006
SPECIFIC DATE 88 - 08/21/2006
SPECIFIC DATE 89 - 08/22/2006
SPECIFIC DATE 90 - 08/23/2006
SPECIFIC DATE 91 - 08/24/2006
SPECIFIC DATE 92 - 08/25/2006
SPECIFIC DATE 93 - 08/27/2006
SPECIFIC DATE 94 - 08/28/2006
SPECIFIC DATE 95 - 08/29/2006
SPECIFIC DATE 96 - 08/30/2006
SPECIFIC DATE 97 - 08/31/2006
EXCLUDE DATE 0 - 12/24/2005
EXCLUDE DATE 1 - 12/25/2005
EXCLUDE DATE 2 - 12/26/2005
EXCLUDE DATE 3 - 12/31/2005
EXCLUDE DATE 4 - 01/01/2006
EXCLUDE DATE 5 - 01/02/2006
EXCLUDE DATE 6 - 03/31/2006
EXCLUDE DATE 7 - 04/01/2006
EXCLUDE DATE 8 - 04/02/2006
EXCLUDE DATE 9 - 04/09/2006
EXCLUDE DATE 10 - 04/16/2006
EXCLUDE DATE 11 - 04/23/2006
EXCLUDE DATE 12 - 04/30/2006
EXCLUDE DATE 13 - 05/01/2006
EXCLUDE DATE 14 - 05/06/2006
EXCLUDE DATE 15 - 05/07/2006
EXCLUDE DATE 16 - 05/08/2006
EXCLUDE DATE 17 - 05/13/2006
EXCLUDE DATE 18 - 05/14/2006
EXCLUDE DATE 19 - 05/15/2006
EXCLUDE DATE 20 - 05/20/2006
EXCLUDE DATE 21 - 05/21/2006
EXCLUDE DATE 22 - 05/22/2006
EXCLUDE DATE 23 - 05/27/2006
EXCLUDE DATE 24 - 05/28/2006
EXCLUDE DATE 25 - 05/29/2006
EXCLUDE DATE 26 - 06/03/2006
EXCLUDE DATE 27 - 06/04/2006
EXCLUDE DATE 28 - 06/10/2006
EXCLUDE DATE 29 - 06/11/2006
EXCLUDE DATE 30 - 06/17/2006
EXCLUDE DATE 31 - 06/18/2006
EXCLUDE DATE 32 - 06/24/2006
EXCLUDE DATE 33 - 06/25/2006
Maximum MPX: 1
Synthetic: 0
PFI Recovery: 0
Retention Level: 0 (1 week)
u-wind/o/d: 0 0
Incr Type: DELTA (0)
Incr Depends: (none defined)
Max Frag Size: 0 MB
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: (same as policy volume pool)
Daily Windows:
Day Open Close W-Open W-Close
Sunday 000:00:00 032:00:00 000:00:00 032:00:00
Monday 023:00:00 033:00:00 047:00:00 057:00:00
Tuesday 023:00:00 033:00:00 071:00:00 081:00:00
Wednesday 023:00:00 033:00:00 095:00:00 105:00:00
Thursday 023:00:00 033:00:00 119:00:00 129:00:00
Friday 000:00:00 000:00:00
Saturday 000:00:00 000:00:00