I cannot via SSMS change the autogrowth setting for a database. It is currently set to restricted and I want it set to unrestricted. I make the change, click ok and no error appears but when I open it again the change is not there.
I also tried creating a new database and noticed that the autogrowth setting of unrestricted is not copied from the model db to the new one.
This happens only with the log file. I have SQL 2005 SP1. Any help is appreciated.
What recovery model are you using, Simple or Full?|||I'm using Full recovery mode.|||Hi Heather,
The maximum size for a log file in 2005 is 2TB. I'm betting that although filesize is displaying as "restricted", the MAXSIZE is indeed 2TB (2,097,152MB). So, within the confines of capacity limitations, it is unlimited so to speak 
Cheers,
Rob
No comments:
Post a Comment