Lost columns and keys to mdf.

Question

Long story short we had a database to get corrupt. I was able to recover the tables but lost our columns, keys, etc. I have a blank database with all the columns, keys, etc. How can I get the data from the tables of the recovered database into the blank database?

Thanks

Answer 1

Sorry Brian, your statement doesnt quite make sense (to me at least) are you saying that you have sets of two tables now.

One with key columns but no dependant data

Another with no key columns but the data

Is that correct and if so how did you get to that position?

---

Regards,
Mark Broadbent.

Contact me through (twitter|blog)

---

Please click "Propose As Answer" if a post solves your problem
or "Vote As Helpful" if a post has been useful to you

Answer 2

Hello Brian,
You statement is very confusing as mention by retracement, can you please bit more specific to the topic so we can understand the things clearly? On the other hand you can restore corrupt database from a good known backup. In case you don't have any backup then try Stellar SQL recovery software. It repairs corrupt table, keys, indexes, constraints and many more. Visit Stellar's official website for more details.

---

Read my blog (Blog)
Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you