When an MS SQL Server database is being restored, and either errors out or times out, and the staus of "Restoring" persists, even after a restart and a clear failure of the Restore operation, use the following to ge things back up, quick 'n dirty style.
Stop MSSQLSERVER and related services.
Open your DATA folder, or wherever the .LDf and .MDf files are stored (of the DB being restored).
Move the files to another folder
Restart SQLSERVER service (and related services).
Start my MS SQL Management Studio and delete the database in question.
Make sure the *.LDF and *.MDF files are gone from their original location folder.
A. Delete the database in question and attempt the restore from scratch; OR:
B. Take the database Offline, copy the .LDF and .MDF files into the DATA directory (from Step 3).Bring database Online.