Dump and Backup Devices
Go Up to [[Supported Objects{{#if:||{{{2}}}}}]]
Dump devices store backups of databases and transaction logs. In Microsoft SQL Server, dump devices are renamed to backup devices.
Before you can dump a database or its transaction log, first create a dump device that stores the resulting backup file. Microsoft SQL Server and Sybase ASE lets you create tape and disk dump devices. Disk dump devices are a fast and convenient mechanism for backups. Tape dump devices facilitate off site storage for enhanced disaster recovery.
Creating and editing
- Backup Devices Wizard (SQL Server) and Backup Devices Editor (SQL Server)
- Dump Devices Wizard (Sybase ASE) and Dump Devices Editor (Sybase ASE)
DBMS platform availability and object actions/operations supported
The following table lists object actions available for this object type. For an introduction to object actions and details on usage of specific actions, see Object actions.
| Object Action | SQL SVR | SYB ASE |
|---|---|---|
|
✓ |
✓ | |
|
✓ |
✓ | |
|
✓ |
✓ | |
|
✓ |
✓ | |
|
✓ |
