cancel
Showing results for 
Search instead for 
Did you mean: 

Last database backup date not being updated on SQL servers

sql_noob
Level 4
we run full backups on weekends and a diff on weekdays. i seem to remember in versions 5 and 6 every time you ran a differential backup, and checked the Last Database Backup date via the SQL tools for that database it would show that time and date. i'm testing on 6.5.3 and the backup goes through with status 0, but the Last Database Backup date and time is from the full backup and running a diff doesn't change it.
2 REPLIES 2

Sriram
Level 6

First are you able to see the correct date from netbackup. 

Do this

bpimagelist -policy <SQL policy name> -U -d 05/01/2009

This will display all the FULL and INCR backups run through <SQL policy name> from 05/01/2009.

If you are able to do the above then post and try to get it from SQL forum.

sql_noob
Level 4

i've done this via the NB SQL client GUI and it shows all the full and diff backups. even did a few test restores and the diff backups restored.