August 22, 2019 at 3:42 pm
MSSQL version: 2016 (13.0.5026.0)
Situation: Removed a database from an availability group so it could be restored. When I'm ready to add it back to the group, I go to drop the copy on the secondary instance. It's in the "restoring" state, but that's ok, that's what's expected. But when I try to drop the database, I get an error message saying "the database is in use". When I see what is blocking me, I see a "VDI_CLIENT_WORKER" process. I can't kill it because it's not a user process.
Any ideas what I can do, aside from restarting the instance? And how to prevent this in the future?
August 22, 2019 at 5:47 pm
VDI_CLIENT_WORKER is usually created when using automatic seeding. You could try disabling along the lines of:
ALTER AVAILABILITY GROUP YourAGName
MODIFY REPLICA ON 'NameOfSecondaryReplica'
WITH (SEEDING_MODE = MANUAL)
Sue
August 22, 2019 at 7:03 pm
Thanks, someone else was able to drop it - I'm not yet sure how, though.
August 22, 2019 at 7:47 pm
If you could find out and post back, that would be great. It helps when others find the same issue that you posted and then they can see how you got it resolved.
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply