Quote Originally Posted by PAVB View Post
Please do tell you have the DDL needed to recreate these FKs.

If the whole process is done during a maintenance window you may want to recreate FKs with NOVALIDATE option -just to do it faster.
Absolutely, PAVB.

I ensured that I had all relevant scripts and also a logical backup (in production, I would do both physical and logical backup).

And thanks for the NOVALIDATE tip; I would have done the same during the actual process.

Thanks again everyone, for the quick reply with resolutions and tips!

Suhas