Post reply

dump transaction

  • July 22, 2010 at 6:26 am

    #235676

    SQL 2000 - DB is FULL recovery model

    One of my vendors created a job that runs this command every night at midnight:

    dump transaction <db_name> with no_log

    Does this command break the log chain? :unsure:

    Wil it impact my restorability of the log files?

    There shouldn't be any activitiy during the night on this app.

    Thanks in advance!

  • July 22, 2010 at 6:33 am

    #1196799

    rothj (7/22/2010)

    SQL 2000

    Does this command break the log chain? :unsure:

    Will it impact my restorability of the log files?

    it certainly does and it certainly will. Its a last resort command when log is so full it cannot even record the fact a log backup is taken.

    If database is in simple mode remove command completely. if in bulk-logged or full recovery replace it with

    backup log dbname to disk = 'file path'

    note new syntax.

    ---------------------------------------------------------------------

  • July 22, 2010 at 6:35 am

    #1196801

    Thanks for your reply.

    We do have nightly Full Backups and hourly log backups from 8 am to 6 pm.

  • July 22, 2010 at 6:36 am

    #1196802

    thats good, then i would get rid of that command and kick your vendor 🙂

    ---------------------------------------------------------------------

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply