Is your database stuck in (Restoring…) state?
Easy!Here, I have a database called debug, stuck in the restoring state.I run this script:
Results should return something like this:
RESTORE DATABASE [debug] WITH RECOVERY |
Results should return something like this:
RESTORE DATABASE successfully processed 0 pages in 5.414 seconds (0.000 MB/sec). |
For resolving out present question you may use mdf recovery. It can work with big invalid sql databases, uses high end methods for repairing crashed or deleted sql data. The software owns clear and intuitive interface being suitable for any experienced users.
ReplyDeleteI was stuck for an hour or so... found your post and it worked like a champ. Thanks!
ReplyDelete