One of the many tasks of anybody who works more in depth with databases is the restoring of data.
Not being completely adept at this practice myself – mostly because it is rare that we administrate production databases – it is something I’m looking into at times.
Occasionally – I’ve seen databases being stuck in “Restoring” state. Basically without getting all to technical (because that’ll be a blog piece for another time), it is mostly because the Database is restored with the “NORECOVERY” clause, so it is ready to be rolled forward with transaction log backups.
So – a method of bringing a database back from restoring state is to run the script:
RESTORE DATABASE <DATABASE_NAME>
WITH RECOVERY
This has worked for me so far anyways… 
Perfect! Worked great for me! Thanks..
Raymond
Kewl it worked for me as well
I removed mirroring for principal db and partner db got stuck into restoring state
u gave me magic solution
Sathy
Glad it can help – had the issue myself and it bugged the heck out of me.
No joy for me. I inherited a failed log shipping installatin from a previous DBA and when I executed the script the following error occured.
"Msg 4333, Level 16, State 1, Line 2
The database cannot be recovered because the log was not restored."
I want to take the DB offline for a period, then archive it to offline storage and get disk space back. Noone who currently works here knows what the database is for, or if anyone uses it.
unluck for me. I got “The database cannot be recovered because the log was not restore”
Sounds like you’re trying to restore a backup with the log files missing or incomplete.
Good stuff. Can I quote you on my blog?
Awesome, worked like a charm.
Very good article. I’ve found your blog via Bing and I’m really happy about the information you provide in your articles. Btw your blogs layout is really messed up on the Chrome browser. Would be cool if you could fix that. Anyhow keep up the good work!
That worked for me. Thanks for the tip
Cheers
No love here either:
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.
Great job….putting this in my toolbelt of scripts.
Thanks a lot. Grate Tip.
Right Solution
This worked for me, just fine. Did have to close and reopen SQL to get the databases to not display as Restoring.
Thank you for posting this!!
super!!!! amazing tip…worked like a charm..
Thanks for the post. Setup a transaction log backup job using database maintenance. Made the mistake of selecting “Back up the tail of the log, and leave the database in the restoring state” This left all the database in the restoring state after the first execution of the log backup. The RESTORE Database WITH RECOVERY resolved the issue.