troubleshooting Question

SQL 2008 database in restoring mode

Avatar of espanolanthony
espanolanthonyFlag for United States of America asked on
Microsoft SQL ServerMicrosoft SQL Server 2008
3 Comments2 Solutions439 ViewsLast Modified:
I was restoring the database from a backup with NORECOVERY option, then applied all the logs sequentially with NORECOVERY option, and here I made the mistake also applied the last log with NORECOVERY option. I should have done with RECOVERY option but just forgot. Now the database is in restoring mode and no trans logs to apply so how do i bring the database back to normal from recovery.
SQL Server DBA
Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros