I think I must have misunderstood something.  The "Correct Answer" section lists the first three options as being the correct answers.  The Explanation section then goes on to say "All...

I think e4d4 is right.  Only use NORECOVERY in a BACKUP LOG statement if you intend to restore over the database you're backing up.  You should be able to bring...

Try this.  It involves a triangular join, so performance may not be good on large data sets.

WITH BeginningsandEndings AS (
    SELECT
       ...

SELECT
     dBookedTill AS FreeFrom
,    LEAD(dBookedFrom,1) OVER (ORDER BY dBookedFrom) AS FreeTo
FROM @t
UNION ALL
SELECT
     NULL
,    MIN(dBookedFrom)
FROM @t
ORDER BY FreeFrom

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...