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.