|
Home > Archive > MS SQL Server > November 2006 > DUMP TRANSACTION
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Tom Reis 2006-11-16, 7:12 pm |
| 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.
| |
| Paulo Condeça 2006-11-16, 7:12 pm |
| 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.
>
>
>
| |
| Scott Morris 2006-11-16, 7:12 pm |
| "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?
|
|
|
|
|