Description:
Database backup.
Syntax:
BACKUP DATABASE database
TO DISK |
TAPE = physical_backup_device_name
[
WITH
[
DIFFERENTIAL ]
[ [,]
INIT |
NOINIT ]
[ [,]
LOG ]
[ [,]
NAME = name ]
[ [,]
DESCRIPTION = description ]
[ [,]
PASSWORD = password ]
]
database |
Name of the backed up database. |
physical_backup_device_name |
Name of the physical device for the backup (file or tape). |
TO DISK |
Physical device for the backup is a file. |
TO TAPE |
Physical device for the backup is a tape. |
WITH |
Clause prefaces possible accessory backup parameters. |
DIFFERENTIAL |
Flag of incremental backup (change from the last backup). |
INIT |
Delete old backups in the device. |
NOINIT |
Keeping old backups in the device and adding new backup to the end. |
LOG |
Backup only transaction log. |
name |
Name of the backup set. |
description |
Description of the backup set. |
password |
Password of the backup set (if stated, then it is required on restoring the database). |
Example1:
Creating the backup of the whole database 'pm_data' in the file with the preservation of possible old backups in this file.
BACKUP DATABASE pm_data TO DISK='c:\temp\pm_data.bak'
Example2:
Creating the backup of the whole database 'pm_data' in the file while removing possible old backups in this file.
BACKUP DATABASE pm_data TO DISK='c:\temp\pm_data.bak' WITH INIT