• Trick question indeed. Another reminder to not not answer a question while there are assumptions on the table: by stating that transaction log backups run from midnight on, there is an assumption that they stop at some time previous to midnight (thereby necessitating the start).

    One could say the statement was false or intentionally misleading. The 'from midnight on' phrase would more accurately be ' since midnight on the the date we started the server ' or something to that effect.

    Mark
    Just a cog in the wheel.