PHWinfo - Afficher un message - SQL Server 2005 Transaction Log Autogrowth

30/03/2008, 19h28

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.

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

"Jose Branco" <Jose Branco@discussions.microsoft.com> wrote in message
news:3BD0CD1D-5D6A-48F7-B772-D8E7CB421553@microsoft.com...
> 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Ã©

30/03/2008, 19h28	#2
Tibor Karaszi Messages: n/a Hébergeur:	Re: SQL Server 2005 Transaction Log Autogrowth 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. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Jose Branco" <Jose Branco@discussions.microsoft.com> wrote in message news:3BD0CD1D-5D6A-48F7-B772-D8E7CB421553@microsoft.com... > 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Ã©