When a lot is connected to your database, this error "has exceeded the lock request timeout period" Workaround for the SQL Server database being restored

1) Manager does not actively refresh, need to manually refresh to see the latest status (performance considerations)

2) In rare cases, the recovery process is suspended. This time assume that you want to recover and return to the accessible state, to execute:
RESTORE Database dbname
With recovery
This allows the recovery process to end completely.
3) If you want to continue to restore the log files later, you do need to put the database in the "Restoring State",

This is usually done with the following command:
RESTORE Database dbname WITH NORECOVERY

When a lot is connected to your database, this error "has exceeded the lock request timeout period" Workaround for the SQL Server database being restored