Hi,

Does anyone out there have a solution to duplicate data enteries when archiving data using the Database/Object Transfer in
Microsoft SQL Enterprise Manager ?

No matter what combination of Copy Data and Replace Existing Data I use I still seem to get
duplicate enteries.

If I use a backup and restore technique to do my Archives will this overwrite any data that previously existed in the database I am
restoring to ?

What is the best method of Archiving when appending data from one database to another and not wanting to overwrite or duplicate enteries ?

I hope someone can help on this. I have tried many options and have not come to a proper solution yet.

Thanks in advance,
Alan