Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

DUMP (Transact-SQL)

SQL Server 2005

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft