The following query will help you to take a backup of the table along with its data.
select * into mytable_backup from mytable
This will make a copy of table mytable, and every row in it called mytable_backup.
Looking for SQL Tutorial? Join the SQL Course to gain more knowledge on SQL.