There is a command VALIDATE DATABASE for that matter. Refer to the help for more info about how to use it. Especially the part about the RECOVER parameter.
It's not a universal problem solver, though. If you have defect tables or indexes, buy foxfix, it can fix very many problems of broken data files.
Unless a bit of data is not important, the cheapest recovery is restoring a backup.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.