Makes a backup copy of a database (DUMP DATABASE) or makes a copy of the transaction log (DUMP TRANSACTION) in a form that can be read into Microsoft® SQL Server™ using the BACKUP or LOAD statements.
Important The DUMP statement is included in SQL Server version 7.0 for backward compatibility. It is recommended that the BACKUP statement be used instead of the DUMP statement. In a future version of SQL Server, DUMP will not be supported.
| BACKUP | sp_helpdb |
| LOAD | sp_helpdevice |
| sp_addumpdevice | sp_spaceused |
| sp_dropdevice |