Example of how to backup a table with SQL for SQL Server

Sql_Server_backup_to_disk.sql

DECLARE @dbName varchar(1000);
DECLARE @exportPath varchar(1000);

SET @exportPath = 'C:\Database_Backups';
SET @dbName = 'YourDatabase';

-- Backs up data in the format: "[DB_name]_YYYY.MM.DD.bak"
SET @exportPath = @exportPath + '\' + @dbName + '_' + 
                (SELECT CONVERT(VARCHAR(12), GETDATE(), 102)) + '.bak';

BACKUP DATABASE @dbName TO DISK = @exportPath;