BACKUP DATABASE my_db TO DISK = 'C:my_db_backup.bak';
CREATE TABLE backup_table SELECT * FROM table_to_be_backed_up;
BACKUP DATABASE databasename TO DISK = 'filepath';
CREATE TABLE actor_backup SELECT * FROM actor;