Tags: bol, command, database, documentation, dump, microsoft, mysql, oracle, running, server, sp4, sql, transaction

DUMP TRANSACTION

On Database » Microsoft SQL Server

1,334 words with 2 Comments; publish: Sun, 01 Jun 2008 23:57:00 GMT; (250217.77, « »)

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.

All Comments

Leave a comment...

  • 2 Comments
    • 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.

      >

      >

      #1; Sun, 01 Jun 2008 23:58:00 GMT
    • "Tom Reis" <reistom.sqlserver.todaysummary.com.cdnet.cod.edu> wrote in message

      news:%23aWjbJZCHHA.4892.sqlserver.todaysummary.com.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?

      #2; Sun, 01 Jun 2008 23:59:00 GMT