Forum Discussion

rookie11's avatar
rookie11
Moderator
13 years ago
Solved

SQL backup failure error code 2

 

Hi guys
 
there r 3 SQL instances on server : default ,server_09,server_08 . instances 09 , 08 completes without any error, but default instance backup fails
both in incremental and full backup 
 
please see the attached log file: dbclient and suggest 
 
no error on event logs
 
netbackup client service running as local system
SQL services running as uk-sqlmaster
 
 
7.1.x and Earlier
Agent for Microsoft SQL Server
Backup and Recovery
NetBackup
Troubleshooting
Windows
  • Douglas_A's avatar
    Douglas_A
    13 years ago

    The error is as stated

     

    er]Login failed for user 'sa'.>

     

    The login for SA failed..

    On the Client/SQL server open the Netbackup MSSQL agent GUI it should prompt you for a login to the DB.. if it doesnt open File > Set SQL server connection properties and reset the Instance name and user and password for the DB.

     

    rerun this hopefully will fix the problem.

  • Will_Restore's avatar
    Will_Restore
    Level 6
    13 years ago

    07:50:01.869 [2776.8928] <32> CUserLogin::ModifyDefaultSQLUseridAndPasswordInReg: ERR - Error in CryptExportKey (for determining size): 2148073475. The text follows:
    07:50:01.869 [2776.8928] <1> CUserLogin::ModifyDefaultSQLUseridAndPasswordInReg:     CONTINUATION: - Bad Key.
     

  • Douglas_A's avatar
    Douglas_A
    Level 6
    13 years ago

    The error is as stated

     

    er]Login failed for user 'sa'.>

     

    The login for SA failed..

    On the Client/SQL server open the Netbackup MSSQL agent GUI it should prompt you for a login to the DB.. if it doesnt open File > Set SQL server connection properties and reset the Instance name and user and password for the DB.

     

    rerun this hopefully will fix the problem.

  • rookie11's avatar
    rookie11
    Moderator
    13 years ago

    used new id and passwrod to login to netbackup SQL GUI ,created a new script but backup failed again.

     

    NBU GUI : nfo dbclient (pid=8768) INF - Error removing ODBC data source name DSN=NBMSSQL_8768_2360_2

  • Will_Restore's avatar
    Will_Restore
    Level 6
    13 years ago

    Cause

    The account running the Netbackup client service does not have permissions to remove the old DSN's.

     

    Solution

    Manually remove all of the old DSN's from the client host

     

    Article URL http://www.symantec.com/docs/TECH185717


     

  • rookie11's avatar
    rookie11
    Moderator
    13 years ago

    finally backup was completed.

    In MS SQL management studio in default instance on left hand tab -- security-- login -- local system account was added through which netbackup client service was running.