A vendor was working on one of our (their) DEV DBs. They were restoring it with something and did something to interupt it or it just got corrupt. I've tried a variety of things that could stop with no luck. finally upon searching for a solution, in a post of some forum foudn from googling, someone stated that you can:
"If no recovery option is specified in your command then it defaults to WITH RECOVERY...
I don't see any problem deleted the db and restoring it...but you can restore on top of db which is in loading status..."
So, therefore, I did a RESTORE, which I can now do after restarting the SQL and Agent services, WITH RECOVERY successfully! If you can not restore which I had previously tried to do getting an error stating it was still in progress of a restore, restart the services first then re-restore with recovery!
Good Luck!
Subscribe to:
Post Comments (Atom)
2 comments:
I have heard about another microsoft sql database recovery tool. Besides, you can visit my blogs at: http://daspeac.livejournal.com/ or http://daspeac.blogspot.com/ where I’m trying to share my experience with regard to data corruption issues.
I hope this will help you to fix this issue.
http://www.sqlrecoverysoftware.net/blog/sql-database-in-recovery-mode.html
Post a Comment