If you have the issue that your database state stuck in the restoring state forever, then you have to execute a single command. Without executing you will not be able to access a database in the restoring state. Execute following command:
RESTORE DATABASE DatabaseName WITH RECOVERY
Then your state will change again back to Normal and you can access the database again.