Post reply

restore sql2000 db to sql2005 drops loses identity properties on primary keys

  • March 6, 2006 at 2:43 pm

    #167995

    To do some testing, I restored a full back of a sql2000 database on a sql2005 server. I was getting some errors and noticed that the primary key fields that were set as identity fields in the sql2000 db are set as identity=false on the sql2005 server. Anyone know why and/or how to get it to maintain that setting during the restore?

    -Phil

  • March 6, 2006 at 4:05 pm

    #625063

    Nevermind. Turns out I was restoring a replicated version of the db that had the identity set to false. The restore of the backup of the primary db is fine. Sorry for the noise...

Viewing 2 posts - 1 through 1 (of 1 total)

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