how to take table backup in SQL Server
--how to take a table backup
--1. scripting out the table
--2. Creating a backup table
select * into backup table from original table
--how to take a table backup
--1. scripting out the table
--2. Creating a backup table
select * into backup table from original table