حذف رکورد تکراری و backup

[AminSobati]

SELECT DISTINCT * INTO NewTable FROM MainTable

GO

SELECT * FROM NewTable