cancel
Showing results for 
Search instead for 
Did you mean: 

SQL incremental backup failure

rookie11
Moderator
Moderator
   VIP   

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Farid_Shaikh
Level 3
Employee Certified

Hi

Please look at the technote below

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

Regards

Farid

View solution in original post

3 REPLIES 3

huanglao2002
Level 6

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
Moderator
Moderator
   VIP   

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

Farid_Shaikh
Level 3
Employee Certified

Hi

Please look at the technote below

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

Regards

Farid