Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

SQL incremental backup failure

Created: 22 Jun 2013 • Updated: 10 Sep 2013 | 3 comments
This issue has been solved. See solution.

Hi 

SQL backup policies. client name TEXPSQL1. full backup runs fine. but incremental backup fails.

message: 06/22/2013 19:43:50 - Info dbclient (pid=2528) DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3035><[Microsoft][SQL Native Client][SQL Server]Cannot perform a differential backup for database "claims", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option. >.

06/22/2013 19:43:50 - Info dbclient (pid=2528) DBMS MSG - SQL Message <3013><[Microsoft][SQL Native Client][SQL Server]BACKUP DATABASE is terminating abnormally.>
 
but same DB is being backedup fine in full backup policy. checking compared full n incr policies client name same on both.
full script:
OPERATION BACKUP
DATABASE $ALL
SQLHOST  "TEXPSQL1"
NBSERVER "masterservername"
BROWSECLIENT "texpsql1.na.att.com"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
 
incremental ;
OPERATION BACKUP
DATABASE $ALL
SQLHOST "TEXPSQL1"
NBSERVER "masterservername"
BROWSECLIENT "texpsql1.na.att.com"
Exclude "master"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
DUMPOPTION INCREMENTAL
NUMBUFS 2
ENDOPER TRUE
 

Not really sure problem at NBU end or SQL side. May i m missing a point or two.

Operating Systems:

Comments 3 CommentsJump to latest comment

huanglao2002's picture

message: 06/22/2013 19:43:50 - Info dbclient (pid=2528) DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3035><[Microsoft][SQL Native Client][SQL Server]Cannot perform a differential backup for database "claims", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option. >.

From the logs it's mean:

you should do a full backupup of claims database,and then do a differential backup.

rookie11's picture

thats the problem mate. FULL backup runs fine, no problem with it. But incremental backup fails with message which i pasted above.

Farid Shaikh's picture

Hi

Please look at the technote below

http://www.symantec.com/docs/TECH128673

Regards

Farid

SOLUTION