My database stuck in restoring state.
Msg 4333, Level 16, State 1, Line 1
The database cannot be recovered because the log was not restored.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Restore the first backup with Restore with NORECOVERY option and last with Restore with Recovery. I guess, you are selecting the Restore with Recovery option with the first backup. It could be a reason of getting this error.
Do not detach database in this situation. Set it into emergency mode ALTER DATABASE DB_NAME SET EMERGENCY DBCC CHECKDB (‘DB_NAME’) Set database into single user mode: ALTER DATABASE DB_NAME SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CHECKDB (DB_NAME, REPAIR_ALLOW_DATA_LOSS) Note: be careful while using repair allow data loss option. With this, you may lose some data.
After that, you need to set your DB in multi-user mode:
DBCC CHECKDB DB_NAME SET MULTI_USER
Yes, I agree with Ahmad. You should run DBCC CHECKDB to find the database inconsistency. Repair allow data loss is last resort to fix this issue. You can also check more references available on web related to your issue.