gopal kannan

gopal kannan

  • NA
  • 65
  • 0

Identity and primary key lost during import in sql 2008

Apr 22 2013 3:09 AM
hi..

in sql server 2008 i used to import my database to another server with values and all my constraints loss using import database option.

but after importing i noticed, my destination database does not contain any constraints like primary key and identity set.

how to handle this issue.

need ur suggestions with examples.

Note:
  i need to restore the d/b via import/export and some other option only.
i dont have  remote server direct access for restoring the database.


regards
gopal.s