Hi Jon,

This is what I mean:

Create a new database called TEST in full recovery mode. It has never been backed up and shows as:

DatabaseName recovery_model BackupType LastBackUpTaken

TEST No Backup Taken No Backup

Backup the database and this now shows as:

DatabaseName recovery_model BackupType LastBackUpTaken

TEST FULL Full Dec 11 2012 10:53AM

But what I would find useful is to show that while the database had a full backup, it has never had a transaction log backup.

This is important as I have seen many cases of a database set up by vendors where the database is in full recovery mode.

It has regular full backups but never a transaction log backup.

This often results in the transaction log being larger than the main data file.

I think it would be useful to show something like the second row below:

DatabaseName recovery_model BackupType LastBackUpTaken

TEST FULL Full Dec 11 2012 10:53AM

TEST FULL Log Never

Regards,

DBA Pete.