Backup a table using T-Sql in MsSql

Hello everyone,

I just wanted to share a short code snippet to help you backup a table using T-Sql in MsSql.

It is very useful if you are working with vital data and do not want it to be ruined. Or you may want to guarantee the latest version of the database.

 SELECT * INTO BackupTableName FROM NameOfDataBaseTableToBackup

NameOfDataBaseTableToBackup represents the name of database table to be backed up.
BackupTableName represents new table that will contain the table data to be backed up.

Hope it helps!

Leave a Reply

Your email address will not be published. Required fields are marked *