DUMP

Transact-SQL Reference

Transact-SQL Reference

DUMP

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 2000 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.

See Also

BACKUP

LOAD

sp_addumpdevice

sp_dropdevice

sp_helpdb

sp_helpdevice

sp_spaceused