Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am confused what this autogrowth property does for any database or log file in SQL Server.

According to my understanding:

  1. If we set autgrowth for database as restricted then its size will increase with data up to this limit and after stops increasing its size which will result in database failure.
  2. If we set autgrowth for database as unrestricted then it will grow until disk space is full.
  3. If we set autgrowth for log file as restricted then logs size will increase upto specified limit and then it will start discarding old logs and new logs will be there in logs.
  4. If we set autgrowth for log file as unrestricted the then it will grow until disk space is full.

Please help me to know if this assumption is correct and if it is wrong then please correct me.

share|improve this question
add comment

migrated from stackoverflow.com May 16 '13 at 7:12

This question came from our site for professional and enthusiast programmers.

1 Answer

If we set autgrowth for log file as restricted then logs size will increase up to specified limit and then it will start discarding old logs and new logs will be there in logs.

This is wrong. If it has to grow it will grow until the max size and after which further growth request will result in failure. You are confusing things with log truncation, which is the process which allow log physical file to be reused (so it doesn't have to grow). I have an article explaining how log grows and what is the role of truncation in this, see How to Shrink SQL Server log.

share|improve this answer
    
+1 for the great article on log shrinking. –  KookieMonster May 16 '13 at 8:06
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.