November 13, 2013 at 1:29 pm
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
November 13, 2013 at 3:35 pm
When it is hung, run sp_whoisactive to see if some peculiar wait shows up.
Also, can you restore the log file MANUALLY?
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply