Expand All
Collapse the table of content
Expand the table of content
Expand Minimize
The document is archived and information here might be outdated

DUMP (Transact-SQL)

The DUMP statement is included for backward compatibility. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Instead, use BACKUP.

Makes a backup copy of a database (DUMP DATABASE) or a copy of the transaction log (DUMP TRANSACTION). The backup copy or log copy created by DUMP can be read into the Microsoft SQL Server 2005 Database Engine by using BACKUP or RESTORE. To maintain backward compatibility, you can use the DUMP keyword instead of the BACKUP keyword in your BACKUP statements. In addition, you can use the TRANSACTION keyword instead of the LOG keyword. The SQL Server Database Engine interprets DUMP DATABASE or DUMP TRANSACTION the same as BACKUP DATABASE or BACKUP LOG, respectively.

© 2016 Microsoft