• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 794
  • Last Modified:

SQL server 2008R2 - Db autogrowth Unrestricted reverts back to Restriced after refresh


When creating a new db in 2008r2, I select the Unrestricted autogrowth for the log file and then save the properties. When checking the properties again, I see that its back to Restricted.

Any idea why this is happening?
Any fixes?

Thank you.
1 Solution
Ephraim WangoyaCommented:
That's how it works, the size limit given is quite large so its inconceivable to reach (2097152MB)
Theres no problem
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now