Depending on how your database got to this stage you might be able to do this
restore database DatabaseName with recovery
This will work if you did a tail log backup or if your database was part of a log shipping topology.
Can you give us any details on how this database got this way?
How can we fix the RESTORING status on SQL Server 2012. The scenario is we dont have .bak file the only file that we have is .mdf and log file? can someone help us on our issue.
ShashankPlease mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it
My TechNet Wiki Articles