A table is a collection of data that is organized in rows and columns. In order to protect your data, you should regularly back up your tables. This article will show you how to take a table backup in SQL Server.
To back up a table, you can use the T-SQL BACKUP command. The following example will back up the MyTable table to the C:\Backups folder:
BACKUP TABLE MyTable TO DISK = ‘C:\Backups\MyTable.bak’
If you want to back up only …
