I have a table in which the primary key is a GUID with a default of NewID. If the PK column had a value of XYZ when I backed it up, I would expect XYZ in the restored table. In fact I get PQR (well the GUID equivalent). It looks like the GUID gets regenerated on restore. Is this in fact happening (it seems a little crazy), and if so, how can it be avoided?I have a table in which the primary key is a GU