Forum Discussion

johnson_Mpaulo's avatar
16 years ago

MS SQL database backup



Dear All,

I have a problem with backup of a SQL database. I have created various scripts and they seem to be initiating the connection with the master server. But i can't figure-out the problem now. Check the error below.

OPERATION BACKUP
DATABASE "UAT"
SQLHOST "dsrv10"
NBSERVER "DDBBACKUP"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE

ERR - Error in CDBbackrec::CDBbackrec: 6.
CONTINUATION: - The system cannot find the file specified.
ERR - Error in VxBSASetEnv(BSA_SERVICE_HOST): 6.
CONTINUATION: - The handle used to associate this call with a previous VxBSAInit() call is invalid.
INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\sqltest.bch>:
<0> operations succeeded. <1> operations failed.
INF - The following object(s) were not backed up successfully.
INF - UAT

  • check if the user who is performing this backup is having access to ms sql database.
    If NBU agent is running on local system account change it to any other with admin privileges on this box and grand this user to with admin privileges on mssql
    here is a quoatation from NBU for mssql doc
    "When the NetBackup scheduler is used, backup operations are launched from a daemon process called the NetBackup Client Service. You must ensure that the
    Client Service has SQL Server privileges to perform backup and restore operations. If you are using integrated security, then you must ensure that the NetBackup Client Service specifies a Windows account that has been granted SQL Server administrative privileges."
  • HI

    This is basically a hostname resolution issue. Check following things on the sql database server

    1. Client recognizes master and media servers. The Master and media servers should be listed in this key:

    HKEY_LOCAL_MACHINE\SOFTWARE\VERITAS\NetBackup\CurrentVersion\Config\
    Keyname = Server
    keyType = REG_MULTI_SZ
    Value = Hostnames of master and media servers

    2. Client should be able to resolve the hostnames to ipaddresses

    3. Client should be able to access these ports on the master server (telnet)

    13724, 13720, 13782

    4. Open a command prompt, and browse to this directory

    C:\Program Files\VERITAS\NetBackup\bin

    run these commands (Every command will return an output. If it doesn't it means there is a problem):

    bpclntcmd -pn
    bpclntcmd -hn MasterServerHostname
    bpclntcmd -hn MediaServerHostname
    bpclntcmd -ip MasterServerIP
    bpclntcmd -ip MediaServerIP

    Also review this technote.

    http://seer.entsupport.symantec.com/docs/278718.htm