identify MS SQL backup times

[office politics]

Differential/Log backup of SQL database fails with the error "The Backup Exec SQL Agent was not used to create the last full backup of this database. You must use the SQL Agent to run a full backup before you run a differential backup or transaction

1. Make sure no SQL backups run outside Backup Exec (including SQL in-built utility for Backups and Restores) as that would interrupt the continuity of SQL backups within Backup Exec schedule causing the job to fail.

Run the following query against the MSDB database for the SQL instance.

select name, backup_start_date
from msdb..backupset
where database_name = 'dbname'
order by backup_start_date desc

where the "dbname" needs to be replaced with the actual database name for which the job fails with the above error.

 

[brady]

trying to find the time of the "sql built-in" or the start time through backup exec?

 

[office politics]

the query shown in the original post will show both in one resultset.

i found errors in veritas when trying to perform a differential backup of SQL DBs. Veritas linked me to the article. After running the query I saw that SQL was setup to perform a full backup every night. This was causing the daily differentials to fail in veritas.

edit - it's good to see you again brady. long time no see.