Export (0) Print
Expand All
Expand Minimize
4 out of 8 rated this helpful - Rate this topic

DUMP (Transact-SQL)

SQL Server 2005

ms187315.note(en-US,SQL.90).gifImportant:
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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.