SELECT
d.name [Database],
d.recovery_model_desc [RecoveryModel],
MAX(b.backup_finish_date) [BackupDate]
FROM
master.sys.databases d LEFT OUTER JOIN msdb..backupset b
ON b.database_name = d.name
AND b.type = 'L'
GROUP BY
d.name,
d.recovery_model_desc
ORDER BY
d.name;
Your resultset will be a little something like this:
If the database recovery models are correct, then you may need to get some backups into place on that Orders database.
See this for more details on SQL Server's transaction log backups:
No comments:
Post a Comment