SQL archive

I am new in the world of SQL. I am trying to figure out how I can archive my data without replacing it with new data, because each time I enter a new data and update it, it will replace the original data.
I am open to any sugestions either from JAVA or Visual Basic experts as well.

Thanks,

Reza