when the database is in the restoring state try the following command and see if the database comes back online
alter database mydata with recovery
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉