Post reply

How to shrink database and truncate log on check p

  • November 26, 2001 at 12:09 am

    #157753

    Sql server 7.0

    How to shrink database and truncate log on checkpoint from a job which will run at night for e.g.

    Thank you in advance,

    ERAN

    ERAN

    ERAN


    ERAN

  • November 26, 2001 at 2:39 am

    #420375

    If you want to shrink the database and you can set up a maintenance plan and schedule it which will create the job. However, you ask about truncate log on checkpoint - do you have this enabled or disabled? If it is enabled (this is only ok for a test system where you don't require point in time recovery) then the CHECKPOINT command should do it, but is probably not needed as checkpoints occur often automatically anyway. If it is disabled, the inactive portion of the log is truncated on backup of the log, and you could add this backup to the maintenance plan.

    Paul Ibison

    Paul.Ibison@btinternet.com


    Paul Ibison
    Paul.Ibison@replicationanswers.com

Viewing 2 posts - 1 through 1 (of 1 total)

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