How to Copy and Backup Table in Database

SELECT INTO Statement  is Most often used to create backup Copies of tables
SYNTAX

SELECT * INTO new_table_name FROM old_table_name

EXAMPLE

SELECT  * INTO backupcopyemp2014

from emp