DUMP (Transact-SQL)

Important

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.

See Also

Reference

BACKUP (Transact-SQL)
sp_addumpdevice (Transact-SQL)
sp_helpdevice (Transact-SQL)
RESTORE (Transact-SQL)

Other Resources

Backing Up and Restoring Databases in SQL Server
How to: Back Up the Transaction Log When the Database Is Damaged (Transact-SQL)
How to: Create a Full Database Backup (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance