• I think errors will occur, and often I'm not sure of the point of tracing back through restores to find out. It's likely not worth the effort. Even if you have reports for the past, I might learn towards some sort of temporal table type structure rather than restores, though even then I'd trim off older data.

    Maybe it's me, but I think often someone wants a CYA without any organizational value.