Wednesday, March 21, 2012

DUMP TRANSACTION

I am running SQL 2000 SP4. I see the DUMP TRANSACTION command in BOL and
other Microsoft documentation but it doesn't seem to work. Is it still
supported. The command I am using is DUMP TRANSACTION WITH NO_LOG.
Rom Reis,
If you want to truncate the inactive portion of the Transaction Log of your
database, in SQL SERVER 2000 you use the following statement:
Backup Log DBNAME with TRUNCATE_ONLY
The " Dump Transaction " is a 6.x SQL Version Command.
Best Regards,
Paulo Conde?a.
"Tom Reis" wrote:

> I am running SQL 2000 SP4. I see the DUMP TRANSACTION command in BOL and
> other Microsoft documentation but it doesn't seem to work. Is it still
> supported. The command I am using is DUMP TRANSACTION WITH NO_LOG.
>
>
|||"Tom Reis" <reistom@.cdnet.cod.edu> wrote in message
news:%23aWjbJZCHHA.4892@.TK2MSFTNGP04.phx.gbl...
>I am running SQL 2000 SP4. I see the DUMP TRANSACTION command in BOL and
>other Microsoft documentation but it doesn't seem to work. Is it still
>supported. The command I am using is DUMP TRANSACTION WITH NO_LOG.
DUMP TRANSACTION is still supported, but is deprecated. Define "doesn't
seem to work". Does the equivalent BACKUP command do anything differently?
sql

No comments:

Post a Comment