Backing up a SQL table is an important task that every database administrator should know how to do. In this article, we will show you how to back up a SQL table using the Transact-SQL BACKUP command.
The BACKUP command is used to back up a SQL table or database. The basic syntax for the BACKUP command is as follows:
BACKUP {database|table} {TO file_name|device_name}
In the example below, we will back up the AdventureWorks2012 database to the C:\Backups folder:
BACKUP …