Hi,
You can use "select into" statement which will use to backups tables into another tables.
select the data from one table and insert into another table.

Example
select * into temp_table from students