Forum Discussion

amr_seedik_zaky's avatar
amr_seedik_zaky
11 years ago

SQL backup partially successful (Status 1)

i need soluation for problem

 

backup for sql was end with 

1/11/2015 4:25:55 PM - Info bpbrm(pid=4808) validating image for client win-pv7mf6fukq0 1/11/2015 4:25:58 PM - end writing the requested operation was partially successful(1) The job was successfully completed, but some files may have been busy or inacessible

:the requested noperatio patial succesful

the job was successful completly bu some file was busy or un accissable

7.5
Backing Up
Backup and Recovery
NetBackup
Windows Server (2003-2008)
  • Marianne's avatar
    Marianne
    Level 6
    11 years ago
    Please ALWAYS tell us as much as possible about the issue. If you read up about Status 1, you will see that there are many possible reasons and that information in Details tab of the job as well as logs on the client is needed. Here dbclient log on SQL client will help in addition to details. Ensure dbclient folder exists on client under ...netbackup/logs. In the meantime, copy all text in Details tab and post here.
  • Michael_C1's avatar
    Michael_C1
    Level 1
    10 years ago

    I have the similar problem like this:

     

    6/30/2015 9:45:10 AM - Info dbclient(pid=5432) INF - SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]90 percent processed.>  
    6/30/2015 9:45:13 AM - Info dbclient(pid=5432) INF - Thread has been closed for stripe #0    
    6/30/2015 9:45:25 AM - Info dbclient(pid=5432) INF - OPERATION #8 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\full_backup_daily.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 68(34) seconds
    6/30/2015 9:45:27 AM - Info dbclient(pid=5432) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\full_backup_daily.bch>:      
    6/30/2015 9:45:27 AM - Info dbclient(pid=5432) <8> operations succeeded. <0> operations failed.       
    6/30/2015 9:45:48 AM - Info dbclient(pid=6620) ERR - Failed trying to get read access to C:\Program Files\Veritas\NetBackup\DbExt\MsSql\full_diff.bch  
    6/30/2015 9:45:48 AM - Info dbclient(pid=6620)     CONTINUATION: - The system cannot find the file specified.
    6/30/2015 9:45:48 AM - Info dbclient(pid=6620) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\full_diff.bch>:      
    6/30/2015 9:45:48 AM - Info dbclient(pid=6620) <0> operations succeeded. <0> operations failed.       
    6/30/2015 9:46:08 AM - Error bpbrm(pid=7484) from client SZPDWP01UTIL: ERR - command failed: none of the requested files were backed up (2)
    6/30/2015 9:46:08 AM - Error bpbrm(pid=7484) from client SZPDWP01UTIL: ERR - bphdb exit status = 1: the requested operation was partially successful
    6/30/2015 9:46:08 AM - Info bpbrm(pid=7484) validating image for client SZPDWP01UTIL        
    6/30/2015 9:46:11 AM - Info bphdb(pid=7564) done. status: 1: the requested operation was partially successful    
    6/30/2015 9:46:11 AM - end writing
    the requested operation was partially successful (1)

     

    Could anyone help me?