DUMP DATABASE

[John]

Hello, All!
Can anyone explain what happens to Transaction Log
when DUMP DATABASE is issued?

Thanx.
John.

[Don Romano]

From Books OnLine:

"DUMP DATABASE - Specifies that the complete database and transaction log are to be backed up.

If the transaction log is on the same device as the database, using DUMP DATABASE is the only way you can create a backup copy of both the database and its transaction log. However, because DUMP DATABASE does not remove the inactive portion of the log, you must use DUMP TRANSACTION WITH TRUNCATE_ONLY to purge the log of completed transactions. Generally, databases and transaction logs should be stored on different devices; this improves performance and enables unrestricted use of both the DUMP DATABASE and DUMP TRANSACTION statements."

So... the database and transaction log are backed up but the transaction log still contains all transactions (active and inactive) as it (the transaction log) did since it was last dumped with a Dump Transaction command.

Don

On 8/10/98 10:09:05 AM, John wrote:
> Hello, All!
Can anyone explain what happens to Transaction Log
when DUMP
> DATABASE is issued?

Thanx.
John.