Results 1 to 2 of 2

Thread: servername.log

  1. #1
    Join Date
    Apr 2004
    Posts
    3

    Question Unanswered: servername.log

    how to wrap the log file as it's getting big and big
    which sql command i have to use to configure the log file size and wrap paramater


    Thanks

    sanjit

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    There isn't any way to wrap the log from SQL (at least in ASE - don't know about ASA).
    One way to do this under Unix is to:

    cp logfile logfile.save
    cat /dev/null > logfile

    This works reasonably well - just do it at a time when activity on the server is low as there is a small window (between the end of the cp and the cat) where an error message written to the log could be lost.

    Michael

Posting Permissions

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