Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    50

    Unanswered: set the trunc. log on chkpt???????

    HI ALL,
    Please show me how to set the trunc. log on chkpt. database option to TRUE .
    thanks so much

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Re: set the trunc. log on chkpt???????

    Originally posted by thanhtung2003
    HI ALL,
    Please show me how to set the trunc. log on chkpt. database option to TRUE .
    thanks so much
    Tthe log is truncated at checkpoints, when the database is using simple recovery model.
    exec sp_dboption $DB, 'trunc. log on chkpt.', 'on'
    Last edited by harshal_in; 02-19-04 at 06:47.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •