It’s always useful to know when your last full database backup was. One way of doing this is by checking in your backup server log file. Better and easier to script is by using DBCC inside your database.

Using the DBCC dbtable command we print out the structure of the database which also includes the dbt_backup_start field which specifies at what date a full backup was made. Note that it does not tell you if that backup was a success.

Anyhow this is still easier for a Python or shell script then looking into the log  of the backup server.

Example with sqsh:

dbcc traceon(3604);
dbcc dbtable; | grep dbt_backup_start