How to Set Unrestricted Growth Property to True ?

postsaurav

Hi experts,

I am facing a issue which is due to Database Size during multiple Transactions. I was able to find out the cause of issue.

The issue was due to the Transaction file Unrestricted Growth was set to False.

I tried to set it to True from File --> Database --> Alter but no effect. when i re login to database it again set to False.

Is there anyway to set the property to True.

bbrown

You can set it from SQL Server Management Studio. However, you should not be relying on auto-grow to expand the transaction log on a regular basis. Manual expand the file and use a combination of transaction log size and backup frequency to eliminate the need for auto-grow.

Auto-grow should only be considered a safety net.

kine

SQL since version 2005 have no "Unrestricted grow" on transaction logs. There must be a limit. You cannot set "Unrestricted" because if it eat all space on HDD, you will be in trouble...