Have a database on SQL Server 2014 that was stuck in "Recovering" - let it run over the weekend & still not recovered. It was making the Server go unresponsive for the other databases today and want to try restoring from a backup from a week ago. The database would not go off line so I shut the SQL Server down, Renamed the .mdf & .log so the server could not find the files, started up SQL Server, then it let me take that database offline. Just waiting to make sure we don't have other problems. Questions is to get that database back - should be able to select Restore database & select the FULL backup and move it to a new disk while it is still OFFLINE? This is a LARGE database 444GB and want to move it to another drive on the server than whet the database backup was originally was done on.
You should be able to restore from backup and move the database files to a new path. Was there any chance your restore command used "WITH NORECOVERY"? If so, your database would be left in recovering until you brought it online. Did the error logs show any progress on recovering? Any idea how many VLFs you have with this database?