Link to home
Start Free TrialLog in
Avatar of espanolanthony
espanolanthonyFlag for United States of America

asked on

SQL 2008 database in restoring mode

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.
ASKER CERTIFIED SOLUTION
Avatar of Anuj
Anuj
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Rich Weissler
Rich Weissler

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of espanolanthony

ASKER

Awsome guys. Thanks ...