Solution to restoring SQL Server database

1) the manager does not actively refresh the page. You need to manually refresh the page to see the latest status (performance considerations)
2) in rare cases, the recovery process is suspended. In this case, if you want to recover and return to the accessible status, run the following command:
Restore database dbname with recovery
This allows the restoration process to end completely.
3) If you want to continuously restore the following log files, you do need to make the database "restoring ",
This usually refers to executing the following command:
Restore database dbname with norecovery