Results 1 to 2 of 2

Thread: error log cycle

  1. #1
    Join Date
    Sep 2004
    Birmingham, UK

    Unanswered: error log cycle

    Quick question (I hope) regarding the cycling of the sql server error logs.

    I am looking at implementing a daily / weekly job to run the stored procedure "sp_cycle_errorlog", but was wondering if there was any way of stopping the sql server process cycling the logs automatically when it is started? Therefore the logs will only be cycled when the job runs.

    Many thanks.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Long ago there used to be a way to prevent errorlog cycling, but I don't know of one anymore.


Posting Permissions

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