Is there any reason why you're using a RIGHT OUTER JOIN?  Updating the outer table of that join means you're going to be attempting to update rows that don't exist....

Please check the syntax of the UPDATE statement.  The JOINs go at the end, after the assignments, and you need a FROM.

John

I'm afraid you've just discovered one of the reasons why a SQL Server service account should be the account under which the SQL Server service runs... and nothing else.  If...

Have you tried querying SSISDB?

John

Then I'd guess that the user is also a member of a group that is explicitly denied permissions on the schema.  I'm sure you can expand the queries I posted...

If you run these two statements in the database in question, do you get any results?

SELECT * FROM sys.database_permissions
WHERE state_desc = 'DENY'

SELECT *...

You can query the backup tables in msdb to find out the size of your log backups.  Take the largest size of those, add a safety marging of 50% (say),...

Joel

I don't know why that is, but why have you installed SSMS 2014 instead of the latest version, available here?

John

Chris

I suspect this isn't going to be recoverable, especially if it's down to a Microsoft bug.  You could spend days trying to sort it out, or just get...

I'm guessing one of the log restores failed.  Have you looked back through the logs to see what happened?

John