It is fairly simple.
1. You write an Stored Procedure to Delete.
2. Inside the Stored Procedure first Select aqnd Copy the Row to another Table
INSERT INTO Customers2
SELECT Name, Country FROM Customers
WHERE CustomerId=@CustomerId
3. Then in next line you can delete record from the main table.