cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Backup

NolanE
Level 4
Partner Accredited Certified

Hi,
 
I have a problem with my SQL backups the backups completes with a status code of 1 (Partially successful) but I can restore from the backups. This only happens with my daily incr backups.
 
In the selection I only select the database that I want to backup and then run the incremental on the selected database, and this is when I get the error code 1.
2 REPLIES 2

Andy_Welburn
Level 6

e.g. problems report, dbclient log on client.

Oddy
Level 5
Employee
Nolan,

If you are running transactions logs backup this is a common problem.
I would guess you will have messages in the
<install dir>\netbackup\logs\dbclient
log saying that the database is using simple recovery model.

If this is the case you can can open the SQL Studio Manager or Enterprise Manager depending on the sql version and go to properties for the database that is failing and change the Recovery model to use Full under the option tab.

Or you can exclude the databases in the backup batch script you are using.

Oddy