Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2003
    Location
    Longmont, CO
    Posts
    258

    Unanswered: Easy question about server log files

    SQL Server 2000 running on Windows 2000

    Is there a way to set up the SQL Server Log files so that it automatically creates a new one (or overwrites the old one) when the old one is full?

    We keep having people shut out of our web site due to the log file being full. Since we have no DBA I volunteered to try to find out how we can avoid this faux pas in the future.

    Thanks for your help!

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    New idea for Microsoft !!!

    If seriously may be it will be easier to backup transaction log more frequently (if full model) or increase maximal size of log because additional log files will only consume disk space until it is full.

    It needs to find out why log is growing so fast - may be it is because of not closed transaction or something else.

  3. #3
    Join Date
    Jun 2003
    Location
    Longmont, CO
    Posts
    258

    Lost me...

    Sorry, but I'm new at this. Are we both talking about the same thing?

    I'm not talking about the transaction log files that are backed up but of the log found under:

    Management>SQL Server Logs

    This log just shows what SQL Server has been doing, not what the users have been doing.

    Perhaps you can tell me where the interface to make settings for this log can be found?

  4. #4
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621

    Re: Lost me...

    Originally posted by Fly Girl
    Sorry, but I'm new at this. Are we both talking about the same thing?

    I'm not talking about the transaction log files that are backed up but of the log found under:

    Management>SQL Server Logs

    This log just shows what SQL Server has been doing, not what the users have been doing.

    Perhaps you can tell me where the interface to make settings for this log can be found?
    I am taking my words back....

    Right click on SQL Server Log files/configure:

    BOL:

    Configure SQL Server Error Logs
    Use this dialog box to view or specify the following options.

    Options
    Limiting the number of the error log files before they are recycled.

    Check to limit the number of error logs created before they are recycled. A new error log is created each time an instance of Microsoft® SQL Server™ is started. Typically, SQL Server retains backups of the previous six logs, unless you check this option, and specify a different maximum number of error log files below.

    Maximum number of the error log files.

    Specify the maximum number of error log files created before they are recycled. The default is six, which is the number of previous backup logs SQL Server retains before recycling them.

  5. #5
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Ok ... we need to get this clear ...

    First of all .. I dont think it would be the SQL server error logs that are causing the problem.

    Connect to the server ... using QA and run the following commands

    exec xp_fixeddrives

    and

    sp_helpdb 'production_databasename'

    Copy paste results and we will go further.
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  6. #6
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401

    Re: Lost me...

    Originally posted by snail
    Specify the maximum number of error log files created before they are recycled. The default is six, which is the number of previous backup logs SQL Server retains before recycling them.
    And you can create a scheduled to be run daily in SQL Server
    Command to be executed in Job :-
    dbcc errorlog
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  7. #7
    Join Date
    Jun 2003
    Location
    Longmont, CO
    Posts
    258

    Done

    OK, I think I've got this one ironed out now.

    Thanks for the help!

Posting Permissions

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