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

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

Hello:

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.
0
noamco36
Asked:
noamco36
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
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

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