View Single Post
  #3 (permalink)  
Old 07-17-07, 07:17
healdem healdem is offline
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 8,761
nah
sounds more like you are not reloading the tables in precendence order
you will need to make sure that your tables go in the correct sequence to maintain the key integrity.

I would have thought your restore sequence should be
Country
State
City
Member

optionally I think you can switch key constraints on or off as you perform this type of process.. but Im not sure Id reccomend it.. although it can make a significant amount of difference to backup/restore times
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote