BACKUP DATABASE is used to create full backup of an existing SQL SERVER database.

Syntax of BACKUP DATABASE in SQL –

BACKUP DATABASE <database_name>

TO DISK = ‘filepath’;

Example of BACKUP DATABASE in SQL-

BACKUP DATABASE  Northwind

TO DISK = ‘C:\backups\Northwind.bak’;

–This SQL statement will create a full back up of the existng database “Northwind” to C: drive.

BACKUP DATABASE ….WITH DIFFERENTIAL SQLstatement is used to create backup of  the parts of the database that have changed since the last full backup of an existing SQL SERVER database.

Syntax of BACKUP DATABASE ..WITH DIFFERENTIAL in SQL –

BACKUP DATABASE <database_name>

TO DISK = ‘filepath’

WITH DIFFERENTIAL;

Example of BACKUP DATABASE ..WITH DIFFERENTIAL in SQL–

BACKUP DATABASE  Northwind

TO DISK = ‘C:\backups\Northwind.bak’

WITH DIFFERENTIAL;

–This SQL statement will create a DIFFERENTIAL back up of the existng database “Northwind” to C: drive.

Note-

Northwind sample database is used for example.