Dump and Backup Devices
Go Up to Supported Objects
Dump devices store backups of databases and transaction logs. In Microsoft SQL Server, dump devices have been 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.
SQL SVR | SYB ASE | |
---|---|---|
✓ |
✓ | |
✓ |
✓ | |
✓ |
✓ | |
✓ |
✓ | |
✓ |