Modified Date: 11-27-2007
Module: Systems
Version: N/A
Description: Setting the Maximum File Size for a database log file will result in a restricted growth setting. Setting the growth factor to Unrestricted fails to save.
Solution: The Maximum File Size showing in the Restricted File Growth window, 2,097,152 MB translates to 2TB (Terabyte) which is the maximum size for a transaction log file. So, in effect, you still have the Unrestricted File Growth setting. Microsoft says this is only a presentation quirk and not bug.
Attachments: None
Key Words: File growth, transaction log file size, SQL 2005
Additional Resource: FREE on-demand training - Document: 10.040.533 - Americas Training Start Page