SQL – How To Backup A DataBase?
Table Of Content:
- Syntax Of Database Backup.
- Examples Of Database Backup.
(1) Syntax Of Database Backup.
BACKUP DATABASE databasename
TO DISK = 'filepath';
The SQL BACKUP WITH DIFFERENTIAL Statement
BACKUP DATABASE databasename
TO DISK = 'filepath'
WITH DIFFERENTIAL;
(2) Examples Of Database Backup.
Example-1: BACKUP DATABASE Example
BACKUP DATABASE testDB
TO DISK = 'D:\backups\testDB.bak';
Example-2: BACKUP WITH DIFFERENTIAL Example
BACKUP DATABASE testDB
TO DISK = 'D:\backups\testDB.bak'
WITH DIFFERENTIAL;