I'm guessing that your BAKINGDATE column has dates in the format mm/dd/yyyy.  Those don't make any sense in a British environment.  The solution, of course, is to make BAKINGDATE datetime...

Tapinder

In a CTE, use ROW_NUMBER to partition the rows by AttributeID and number them ordered by VersionID DESC.  Then just choose the rows where the row number is...

So you're only keeping 10 hours' worth of log backups?!  When was your last full (or differential) backup made - 2017-11-26T10:41:12?

CleanupTime

Specify the time, in hours,...

You need more detailed logs than that.  Have a look at the Logging section on this page.

John

Please provide sample data in the form of CREATE TABLE and INSERT statements.  How do you determine what rows contain the "recent versions"?

John

In that case, I'm guessing that the connection strings specify msdb as the database.  A quick and dirty fix would be to grant the logins access to msdb; the proper...

Is msdb the default database for the logins that are failing?  If so, probably best to change it either to master, or to whatever single user database the login uses.

You need the full backup, plus every log backup taken after that, up to and including the one taken after the intended recovery point.  It doesn't matter whether the log...

Paul
This will get you somewhere near where you want to be.  It involves three table scans, so there may be a better alternative from a performance point of view.

I've never heard of a NULL collation.  If you want all columns to have the same collation as the database, why not specify that collation by name in the ALTER...