cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Backup error

Kroxa
Level 3

Good afternoon!
Faced with the following problem with the sql database backup:
when you run a backup policy from the master server, see the following

 

27.01.2016 12:33:40 - started process bpbrm (pid=7468)

27.01.2016 12:33:42 - Info bpbrm (pid=7468) m9965-sys202.idmz.rvv is the host to backup data from

27.01.2016 12:33:42 - Info bpbrm (pid=7468) reading file list for client

27.01.2016 12:33:42 - connecting

27.01.2016 12:33:44 - Info bpbrm (pid=7468) starting bphdb on client

27.01.2016 12:33:44 - Info bphdb (pid=5656) Backup started

27.01.2016 12:33:44 - connected; connect time: 0:00:00

27.01.2016 12:33:45 - Info dbclient (pid=6612) INF - Error: Failed to query database metadata for <test>

27.01.2016 12:33:47 - Info dbclient (pid=6612) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\test.bch>:

27.01.2016 12:33:47 - Info dbclient (pid=6612) <0> operations succeeded. <1> operations failed.

27.01.2016 12:33:47 - Info dbclient (pid=6612) INF - The following object(s) were not backed up successfully.

27.01.2016 12:33:47 - Info dbclient (pid=6612) INF - test

27.01.2016 12:34:07 - Error bpbrm (pid=7468) from client m9965-sys202.idmz.rvv: ERR - command failed: none of the requested files were backed up (2)

27.01.2016 12:34:07 - Error bpbrm (pid=7468) from client m9965-sys202.idmz.rvv: ERR - bphdb exit status = 2: none of the requested files were backed up

27.01.2016 12:34:09 - Info bphdb (pid=5656) done. status: 2: none of the requested files were backed up

27.01.2016 12:34:09 - end writing

none of the requested files were backed up (2)

----------------------------------------------------------------

And, if you run the backup script from the client, the backup policy fulfills

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Does it work when you run the backup from the client using a logon account with sufficient SQL rights?

If so, you need to change the NetBackup Client Service logon account on the client from the default LocalSystem account to a user account with sufficient rights.

View solution in original post

4 REPLIES 4

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Does it work when you run the backup from the client using a logon account with sufficient SQL rights?

If so, you need to change the NetBackup Client Service logon account on the client from the default LocalSystem account to a user account with sufficient rights.

PetrHanz
Level 4
Partner Accredited Certified

Hi,

 

if the change of logon account doesn't resolve your problem ( as wrote Marianne) then create log's directories in netbackup\logs on client SQL server,  see https://www.veritas.com/support/en_US/article.000027153 and put here of list bphdb log file and dbclient log file. But I believe that change logon name will succesfully.  

 

Petr

Kroxa
Level 3

Thanks for the help, changed the account for the NetBackup Client Service and backups have started

Moved:

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified