The blocking that occurred happened yesterday was from a Statement that was Deleting from a Table using a Subquery.

This query was placing Exclusive Table Locks.

on two tables.

The Transaction Log was growing and since it did not seem that the Database was Rolling Back, 0%, I made an assumption that it was stuck. Did I make an incorrect assumption?

I had them using locking hints and no more blocking.

After I went through restarting the Service and recovery.

I set the Database Offline but when I attempted to bring it back online and I got an error, something to the effect that the database did not exist or I did not have permissions.

I wonder if I had included with Rollback Immediate I could have avoided this problem?

The Database was stuck offline. I checked the event viewer and I did not see any entries that indicated that the Database was in Recovery.

So I bounced the Service again and shortly after I started seeing entries in the Event Log that the Database was recovering.