Response received from MS. They basically acknowledged the issue and said a fix was being prepared in a new version of SQL (hopefully this is a hotfix and not 2016?!).

As...

We use Ola's scripts and previously checkdb would run for an average of 1.5 hours max for all databases on the server (about a dozen of them - some almost...

Agreed but we will still be taking log backups once a day to netbackup. If any rows were deleted from the primary database, we could take another log backup and...

Superb solution Chris, many thanks!

I'd like to thank everyone else who took the time to reply, you guys made my day a lot easier 🙂

Thanks guys - I am just going into a meeting but I will test the submitted solutions in a bit.

Thank you both for the replies.

Philip, I appreciate your response but I am looking for a solution similar to Shanu's.

Shanu, when I run SELECT cast(dateadd(hh,23,cast(getdate()-1 as int) ) as datetime)...