October 28, 2020 at 2:33 pm
I have an instance where I have sysadmins.
There a number of databases created by users and also msdb where I am unable to set log file growth to unlimited. It seems that when I change the setting all is OK but on checking back it has reverted to limited. I have altered the setting on a number of other DBs without a problem. Can anyone shed any light on this?
October 28, 2020 at 2:59 pm
You talking about the 2TB limit? Thats for logs in general, so even though there is a limit set at 2TB even those databases which dont have the limit set are still bound by that 2TB limit.
SQL sets it so you are aware of the limit once you change the log in some way, there is no way to remove that and is causing you no issues in being there
October 28, 2020 at 3:36 pm
You learn something new every day. Thank you that would explain it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply