SQL

SQL BACKUP DATABASE Statement

BACKUP DATABASE my_db
TO DISK = 'C:my_db_backup.bak';

script sql backup database sql server

-- The BACKUP DATABASE statement is used in SQL Server to create a full back up of an existing SQL database.
Syntax:
BACKUP DATABASE databasename
TO DISK = 'filepath';

--The SQL BACKUP WITH DIFFERENTIAL Statement
--A differential back up only backs up the parts of the database that have changed since the last full database backup.

BACKUP DATABASE databasename
TO DISK = 'filepath'
WITH DIFFERENTIAL;

sql server backup table

SELECT * INTO BackupTable FROM Table

SQL BACKUP DATABASE for SQL Server

BACKUP DATABASE databasename
TO DISK = 'filepath';