Rebuild Primary Key(s) on a table/database

Question

Post reply

Rebuild Primary Key(s) on a table/database

Cory Slaney

SSCrazy

Points: 2459
More actions
November 28, 2005 at 1:26 pm

#188618

I copied a database and for some reason, they some primary keys were not reproduced. What is the best way to rebuild primary keys on a table or entire database?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Atul Varshney-262272 SSC Rookie Points: 33 More actions · Answer 1

You should take Database backup - Complete

to resolve your problem.

Ian Yates SSCoach Points: 19738 More actions · Answer 2

How did you "copy" it? Using DTS, database backup, detach/attach?

Cory Slaney SSCrazy Points: 2459 More actions · Answer 3

I detached the database created copied of the database files and them re-attached.

Kenneth Wilhelmsson SSC-Dedicated Points: 30043 More actions · Answer 4

Hmm... Maybe better check your original db..? I can't see how any objects can disappear when doing a detach-attach. Make sure that the PKs you miss really is there in the original database.

/Kenneth

Cory Slaney SSCrazy Points: 2459 More actions · Answer 5

I did check and verified that some of the primary keys were lost, or I think I had problems re-attaching at that time. So, to restore the original primary keys on a select group of tables, what would be the best approach?

Ian Yates SSCoach Points: 19738 More actions · Answer 6

I think you should recopy the database - if you have somhow mysteriously lost primary keys, you have probably lost other things as well and are lucky it is not marked as suspect in SQL.