I have a server with serveral SQL databases on it. They are all in the default instance. For one specific database I cannot run differential backups. When I try it says that no full backup is available for the database even if I run a full backup directly prior to running the differential backup.
Differential backups work with issue on all my other databases. I am at a loss as to what could be going on. The full backups appear to run correctly. The full backups are good. I can restore them without an issue and all of the data is there.
It seems like for some reason something within SQL isn't recording that a full backup was done.
Any help is greatly appreciated.