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.

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.