• The BOL reference after the explanation doesn't help at all, as it doesn't refer the dump command. Anyway, even in SQL 2000 the dump command was deprecated, MS recommended that it be not used, and of course in the latest SQL Server it is no longer supported. The question would have been far better written using backup log instead of dump transaction.

    Tom