06-22-2013 01:49 PM
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. >.
Not really sure problem at NBU end or SQL side. May i m missing a point or two.
Solved! Go to Solution.
06-24-2013 01:11 AM
06-23-2013 04:35 AM
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.
06-23-2013 09:36 AM
thats the problem mate. FULL backup runs fine, no problem with it. But incremental backup fails with message which i pasted above.
06-24-2013 01:11 AM