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