Results 1 to 2 of 2

Thread: Log file sizes

  1. #1
    Join Date
    May 2007
    Location
    Calgary, Canada
    Posts
    22

    Unanswered: Log file sizes

    When you have the autogrowth turned on for log files. What happens when you put a max file size on it? Will just overwrite the old logs to keep the file at the max size or will it just create a new file every time it hits the max size?

    Thanks!

  2. #2
    Join Date
    Oct 2007
    Location
    Chicago, IL
    Posts
    82
    SQL Server will stop writing to the log file. You'll start seeing error messages on your SPs/queries saying "Transaction Log is full" etc.

    -A

Posting Permissions

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