SQL to create backup of SQL server table

 

SELECT * INTO newtablename FROM Oldtablename

Newtablename is name the name of table where backup would be created.
Oldtablename is name the name of table from where backup would be created