Showing posts with label Backup Table. Show all posts
Showing posts with label Backup Table. Show all posts

Take Backup with Data of single Table in SQL Server

Create Backup table Instantly :

The Following query automatically creates a Table with name "Table_Backup" and Insert all the rows of "Table_Old" into "Table_Backup"

Example :
    SELECT *  INTO  Table_Backup FROM Table_Old