I have a DB I would like to restore. There are other active connections on the DB. I tried using sp_who2 to find those connections and manually kill them. Unfortunately, this did not solve the problem. I am now running the following code to set the DB to single user mode
alter database mydb set single_user with rollback immediate
This code runs for several hours and does not complete. Not sure if something is holding this command up. Is there another way to restore my DB?