I have been looking through my estate pages and in particular, the backup page. I have noticed that my worst RPO in the last 30 days is 22hours and 42 minutes. I found this surprising as we do full / diff / log backups on all databases on this server, with the logs being every 15 minutes
Does anyone know the logic behind this and how I can see where that worst RPO is coming from (What day etc) as all I can see in my environment of note in the last 30 days is that 2 diff backups failed, which makes me think I may have a rogue backup not being set as COPY_ONLY, or similar, though I haven't been able to find anything
Hi,
I have been looking through my estate pages and in particular, the backup page. I have noticed that my worst RPO in the last 30 days is 22hours and 42 minutes. I found this surprising as we do full / diff / log backups on all databases on this server, with the logs being every 15 minutes
Does anyone know the logic behind this and how I can see where that worst RPO is coming from (What day etc) as all I can see in my environment of note in the last 30 days is that 2 diff backups failed, which makes me think I may have a rogue backup not being set as COPY_ONLY, or similar, though I haven't been able to find anything