How to shrink database and truncate log on check p

• eranfox

  Valued Member

  Points: 60

  More actions

  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

• Paul Ibison

  SSCertifiable

  Points: 5303

  More actions

  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