What’s the issue?
There are one or more databases that have not had a full backup completed, or there are one or more databases using the Full or Bulk Logged recovery model that have not had a log file backup completed.
Why is this a problem?
By default, SQL Server does not perform any backups of your databases. If a database is missing a full backup then it is likely unrecoverable.
Also, if your database is using the Full or Bulk Logged recovery model, you will need to perform log file backups at regular intervals. Failing to do so will result in the log file growing until there is no more available drive space.
What should you do about this?
You should probably schedule full backups to be completed at regular intervals for any databases with critical data you may need to recover some day.
Also, if you need to recover data to a point in time between full or differential backups, schedule log file backups to be completed at regular intervals. If you do not need to recover to a point in time between full or differential backups, consider changing your recovery model to Simple.
Read more…
SQL Server Health Check Worst Offenders – SQL Server Consulting – Straight Path Solutions