SQL Backup error
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
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.
