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.
Share this:
Leave a Reply