cancel
Showing results for 
Search instead for 
Did you mean: 

Error 2 Backup too large DB - SQL

Ugo_Morra
Level 1

Hi all,

I have a problem with a too large DB. In the past the script the script has always worked but since a few days it returns error 2 on a given DB both for the Differential and for the transactional log.

This is the script:

OPERATION BACKUP
DATABASE $ALL
EXCLUDE master
EXCLUDE msdb
EXCLUDE tempdb
EXCLUDE model
EXCLUDE SeedDB
SQLHOST "MI-SPOINT-DB01"
NBSERVER "NBUMS-MI3.OPTIMAITALIA.COM"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
OBJECTTYPE TRXLOG
NUMBUFS 2
VDITIMEOUTSECONDS 3600
ENDOPER TRUE

the backup starts correctly but when it arrives at a certain DB (about 4.5 Terabytes large) the dbbackex.exe process on the client reaches about 5Gigabytes of RAM and after a little it returns the error:

ERR - command failed: unimplemented error code 255 (255)

ERR - bphdb exit status = 2: none of the requested files were backed up.

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Have you checked the SQL server Application log for errors? 
Possibly a resource issue?

View solution in original post

4 REPLIES 4

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Have you checked the SQL server Application log for errors? 
Possibly a resource issue?

Nicolai
Moderator
Moderator
Partner    VIP   

Why not open a support case with Veritas ?

Throwing "ERR - command failed: unimplemented error code 255" should be reason enough :)

Alexis_Jeldrez
Level 6
Partner    VIP    Accredited Certified

Try backing up only that database at another moment.

Also, if you have enough disk, ask the DBA to directly do a disk-backup of the database (a .BAK file) in order to confirm NetBackup is the issue.

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
@Ugo_Morra

Thanks,for marking solution, but please tell us what the issue was?