BACKUP DATABASE
BACKUP DATABASE is a SQL statement in the Administration category. Creates a full database backup. SQL Server. For recovery in case of data loss or corruption. The syntax is BACKUP DATABASE database_name TO DISK = 'backup_file.bak';. It returns backup created. A typical example: BACKUP DATABASE my_company TO DISK = 'C:\backups\my_company_full.bak' WITH INIT, COMPRESSION; -- WITH INIT: overwrite existing backup file -- COMPRESSION: reduces file size -- Differential backup: BACKUP DATABASE my_company TO DISK = 'C:\backups\my_company_diff.bak' WITH DIFFERENTIAL; A close relative is CREATE USER, which creates a new database user account. A close relative is GRANT, which grants specific privileges (SELECT, INSERT, UPDATE, DELETE, ALL) to a user on a database/table. A close relative is REVOKE, which removes previously granted privileges from a user. More about this category: Database administration — CREATE DATABASE, GRANT, REVOKE, SHOW, DESCRIBE. Related Administration entries: CREATE USER, GRANT, REVOKE, SHOW TABLES, DESCRIBE / DESC, SHOW INDEX, SHOW CREATE TABLE, SHOW DATABASES.