take a table backup in sql server code example Example: backup a table in sql CREATE TABLE backup_table SELECT * FROM table_to_be_backed_up;