October 3, 2016 at 11:52 pm
Hello Everyone,
I have an Existing DB. I am trying to change the Log FIle growth to unlimited.
I am changing the growth to 10MB and unlimited both using ssms and Tsql.
But the FIle growth is not changed. Should i restart the server?
Thanks in advance
Sanjay,
October 4, 2016 at 3:29 am
File size and growth changes are immediate, no restarts are needed.
How are you checking the growths and how are you setting them?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 4, 2016 at 6:55 am
Tried Using both SSMS - DB_Name-Properties-Files-Log file then changing Filegrowth .
Tsql
ALTER DATABASE <Name>
MODIFY FILE
(NAME=MyDB_Log,FILEGROWTH=10MB);
October 4, 2016 at 7:00 am
That should work fine. Can you post a screenshot of the file properties after running that?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 4, 2016 at 7:20 am
Sorry, How do i attach screenshot.
October 4, 2016 at 8:07 am
Pls find the screenshot here - https://drive.google.com/file/d/0BwQesWwtB8meUDdLS2pIMW8tQkE/view?usp=sharing
It's the screenshot after the update
October 4, 2016 at 8:21 am
The screenshot shows the file growth is 10MB, exactly as the ALTER DATABASE specified. So, what's wrong?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 4, 2016 at 10:44 pm
Yes Gail, It is showing 10MB but the growth is limited to some thousands of MB which was set at the time of DB creation(From a different person).
But, It's so Weird that i found that the setting is changed to unlimited this morning.
As always Thanks for the help Gail.
October 5, 2016 at 1:07 am
Oh, you mean the max size, not the growth.
It's 'limited' to 2TB, which is the maximum allowable size of a log file, so it's essentially the same as unlimited.
Not thousands of MB, 2 million MB (2000 GB, 2 TB)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply