SQL Server 2005 Transaction Log Autogrowth

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jose Branco - 30 Mar 2008 17:17 GMT

Hi,

i´m trying to change this setting on the Sql Management studio database
properties but it doesn´t let me. If i change it to unrestricted it
automaticaly changes to restricted to a specific value.
How can i change this??

Thanks
José

Reply to this Message

Tibor Karaszi - 30 Mar 2008 19:28 GMT

What value is it changed to? Largest possible size for ldf file is 2TB so if this is the value you
see then this value and "unrestricted" is indeed the same and what you see is only a presentation
issue (no functional difference).

Note that the value presented in the GUI is in MB and 2 097 152 MB is indeed = 2TB.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> Hi,
>
[quoted text clipped - 5 lines]
> Thanks
> José

Reply to this Message