11-13-2013 04:47 AM
HI
BCH FILE:
SQLINSTANCE $ALL
OPERATION BACKUP
DATABASE "ReportServer"
SQLHOST "WIN-XR91YPH5L5N"
NBSERVER "X.X.X.X"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
LOG :
13.11.2013 13:13:33 - Info nbjm (pid=1645) starting backup job (jobid=7872) for client WIN-XR91YPH5L5N.X.X.de, policy 1000_mssql_win_2, schedule start
13.11.2013 13:13:33 - Info nbjm (pid=1645) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=7872, request id:{04347B9A-4C5D-11E3-9AD5-9120802BB2A3})
13.11.2013 13:13:33 - requesting resource Disk_Storage_Unit_1
13.11.2013 13:13:33 - requesting resource cobalt.X.X.de.NBU_CLIENT.MAXJOBS.WIN-XR91YPH5L5N.X.X.de
13.11.2013 13:13:33 - requesting resource cobalt.X.X.de.NBU_POLICY.MAXJOBS.1000_mssql_win_2
13.11.2013 13:13:33 - granted resource cobalt.X.X.de.NBU_CLIENT.MAXJOBS.WIN-XR91YPH5L5N.X.X.de
13.11.2013 13:13:33 - granted resource cobalt.X.X.de.NBU_POLICY.MAXJOBS.1000_mssql_win_2
13.11.2013 13:13:33 - granted resource Disk_Storage_Unit_1
13.11.2013 13:13:33 - estimated 0 kbytes needed
13.11.2013 13:13:33 - Info nbjm (pid=1645) started backup (backupid=WIN-XR91YPH5L5N.X.X.de_1384344813) job for client WIN-XR91YPH5L5N.X.X.de, policy 1000_mssql_win_2, schedule start on storage unit Disk_Storage_Unit_1
13.11.2013 13:13:33 - started process bpbrm (pid=3414)
13.11.2013 13:13:34 - Info bpbrm (pid=3414) WIN-XR91YPH5L5N.X.X.de is the host to backup data from
13.11.2013 13:13:34 - Info bpbrm (pid=3414) reading file list from client
13.11.2013 13:13:34 - Info bpbrm (pid=3414) starting bphdb on client
13.11.2013 13:13:34 - connecting
13.11.2013 13:13:34 - connected; connect time: 0:00:00
13.11.2013 13:13:35 - Info bphdb (pid=3576) Backup started
13.11.2013 13:13:41 - Info dbclient (pid=1908) ERR - Internal error. See the dbclient log for more information.
13.11.2013 13:13:41 - Info dbclient (pid=1908) ERR - Error in VxBSAGetPolicyInfo_Ex: 3.
13.11.2013 13:13:41 - Info dbclient (pid=1908) CONTINUATION: - System detected error, operation aborted.
13.11.2013 13:13:41 - Info dbclient (pid=1908) USER - Policy 1000_mssql_win_2 has been selected to back up SQL Server. Verify that it exists and is in an active state.
13.11.2013 13:13:43 - Info dbclient (pid=1908) INF - Results of executing <E:\test\test.bch>:
13.11.2013 13:13:43 - Info dbclient (pid=1908) <0> operations succeeded. <1> operations failed.
13.11.2013 13:13:44 - Info dbclient (pid=1908) INF - The following object(s) were not backed up successfully.
13.11.2013 13:13:44 - Info dbclient (pid=1908) INF - ReportServer
13.11.2013 13:14:04 - Error bpbrm (pid=3414) from client WIN-XR91YPH5L5N.X.X.de: ERR - command failed: none of the requested files were backed up (2)
13.11.2013 13:14:04 - Error bpbrm (pid=3414) from client WIN-XR91YPH5L5N.X.X.de: ERR - bphdb exit status = 2: none of the requested files were backed up
13.11.2013 13:14:04 - Info bphdb (pid=3576) done. status: 2: none of the requested files were backed up
13.11.2013 13:14:04 - end writing
none of the requested files were backed up (2)
My Problem is my Backup failed every Time:
with :done. status: 2: none of the requested files were backed up
an idea ?
THX for HELP
Solved! Go to Solution.
11-13-2013 06:22 AM
14:58:15.843 [3640.1380] <16> VxBSAGetPolicyInfo: ERR - GET_POLICY_INFO request returned: 240 <no schedules of the correct type exist in this policy>
You need both Application Backup and Automatic Backup schedules in your Policy
11-13-2013 09:37 AM
16:22:22.111 [2960.3040] <16> CreateNewImage: Encryption not requested by server, but required by client
Either disable encryption or configure it properly
11-13-2013 05:38 AM
Please check if policy 1000_mssql_win_2 has Application Backup schedule and its start window is open ata that time. Post "bppllist 1000_mssql_win_2 -U" if possible.
Also tell us if this SQL Server is clustered.
11-13-2013 05:42 AM
13.11.2013 13:13:41 - Info dbclient (pid=1908) ERR - Internal error. See the dbclient log for more information.
Have you tried that?
If not, create dbclient folder under ...\netbackup\logs and retry the backup.
Check the log for errors.
One more thing: Check that NetBackup Client Service on SQL server is started with SQL Admin rights account.
11-13-2013 06:01 AM
attached log
thx
11-13-2013 06:15 AM
IF i change the setting to Application Backup
Message:
No automatic backup schedules are defined for the policy(user backup and user archive schedules,if any, are excluded).
No SQL CLuster [Stand alone]
11-13-2013 06:22 AM
14:58:15.843 [3640.1380] <16> VxBSAGetPolicyInfo: ERR - GET_POLICY_INFO request returned: 240 <no schedules of the correct type exist in this policy>
You need both Application Backup and Automatic Backup schedules in your Policy
11-13-2013 06:34 AM
Very THAnks
Now is a new Problem
13.11.2013 15:30:52 - Info dbclient (pid=3824) ERR - Error in VxBSAWaitForFileListStatus: 33.
13.11.2013 15:30:52 - Info dbclient (pid=3824) CONTINUATION: - All backup jobs have failed.
13.11.2013 15:30:53 - Info dbclient (pid=3824) ERR - One or more files could not be archived.
13.11.2013 15:30:53 - Info dbclient (pid=3824) ERR - Internal error. See the dbclient log for more information.
13.11.2013 15:30:53 - Info dbclient (pid=3824) INF - Thread has been closed for stripe #0
13.11.2013 15:30:53 - Info dbclient (pid=3824) ERR - A panic close was issued to dbclient #0.
13.11.2013 15:30:53 - Info dbclient (pid=3824) ERR - Error in VDS->Close: 0x80770004.
13.11.2013 15:30:53 - Info dbclient (pid=3824) CONTINUATION: - An abort request is preventing anything except termination actions.
13.11.2013 15:30:53 - Info dbclient (pid=3824) INF - OPERATION #1 of batch E:\test\test.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 35(35) seconds.
13.11.2013 15:30:55 - Info dbclient (pid=3824) INF - Results of executing <E:\test\test.bch>:
13.11.2013 15:30:55 - Info dbclient (pid=3824) <0> operations succeeded. <1> operations failed.
13.11.2013 15:30:55 - Info dbclient (pid=3824) INF - The following object(s) were not backed up successfully.
13.11.2013 15:30:55 - Info dbclient (pid=3824) INF - ReportServer
13.11.2013 15:31:15 - Error bpbrm (pid=16099) from client WIN-XR91YPH5L5N.x.x.de: ERR - command failed: none of the requested files were backed up (2)
13.11.2013 15:31:15 - Error bpbrm (pid=16099) from client WIN-XR91YPH5L5N.x.x.de: ERR - bphdb exit status = 2: none of the requested files were backed up
13.11.2013 15:31:16 - Info bphdb (pid=3400) done. status: 2: none of the requested files were backed up
13.11.2013 15:31:16 - end writing
none of the requested files were backed up (2)
11-13-2013 06:58 AM
with which file he has a problem ?
11-13-2013 07:09 AM
Again, need dbclient log from latest backup attempt
Also look at Windows Event Viewer for clues
11-13-2013 07:24 AM
Sorry
ok
11-13-2013 09:37 AM
16:22:22.111 [2960.3040] <16> CreateNewImage: Encryption not requested by server, but required by client
Either disable encryption or configure it properly
11-14-2013 12:47 AM
VERY THANKS
ALL Fine
11-14-2013 06:05 AM
So what fixed it?
Don't forget to 'Mark as Solution' or 'Request Split Solution'
11-14-2013 06:07 AM
Done
Solution
1. You need both Application Backup and Automatic Backup schedules in your Policy
2. Either disable encryption or configure it properly