mart 13485 (6/23/2016)
Thanks for the responses. We had to restart SQL Server, affecting all databases, because one of the tables had a lock on it that we were unable to clear any other way. Can you tell me more about standing up a new failover cluster instance in an existing cluster?
Moving the database to a new instance is not going to make the issue go away and you certainly shouldn't be restarting the whole instance to remove a troublesome object lock!
You must find out what's locking the resources and resolve this
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉