I feel like a noob asking this but has anyone encountered a case where the Restore DB job in log shipping fails due with "Unable to acquire exclusive access" even though you've checked the box (and confirmed in the table) that you want all connections closed prior to restoring?
I know the account that's running it has permissions to close the connections because I've written a job that does just that as a stop-gap.
I've tried to search for people having this problem in Google but when you search for things like "sql server 2012 log shipping close all connections fail" you get a bunch of pages telling you to check the close all connections option. So not only am I baffled by this behavior in SQL Server 2012, I apparently have reached the limits of my Google skills. It's making for a humbling day. 😉
Actual SQL version: 11.0.3000