Asked on behalf of TimSki37: Is it possible to recover or restore database constraints in a schema/library that has been cleared and restored from a different schema/library?
We have a library that was cleared of all physical files and tables were restored from a different library. In doing so, however, all constraints were lost and the system/cross-reference tables were corrupted. As a result of the corrupt cross-reference tables, the system also no longer allows for the addition of constraints on these tables.
What steps must occur so that the contraints can be recovered if that is even possible?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!