Backup a table (create a new table)
SELECT * INTO BackupTbl FROM OriTbl;
Backup a table structure
SELECT TOP 0 * INTO BackupTbl FROM OriTbl;
Copy the data to backup table (The backup table is exist)
INSERT INTO BackupTbl SELECT * FROM OriTbl;