SELECT INTO

	SELECT * INTO nome_da_tabela_que_estao_a_mexer_BKP
	FROM nome_da_tabela_que_estao_a_mexer

SELECT CustomerName, ContactName INTO CustomersBackup2017

FROM Customers;