Last morning I was killeing a backup (Sybase IQ). I don’t sure if it ends fine or bad. The issue is this backup is a incremental (from last backup indiferent from backup type) the policy for this database is a full backup on Saturday and incrementals every day of the week. The dude surge where can I see the sucessfully last backup. In this case the next query solve my problem;
SELECT * FROM sp_iqstatus () WHERE name LIKE ‘%ackup%’
I put a screenshot of the result.
Here you can see the last succesfully backup, and other data like estimate size the next incremental backup.
HTH – Antonio NAVARRO