I am confused what this autogrowth property does for any database or log file in SQL Server.
According to my understanding:
- If we set autgrowth for database as restricted then its size will increase with data up to this limit and after stops increasing its size which will result in database failure.
- If we set autgrowth for database as unrestricted then it will grow until disk space is full.
- If we set autgrowth for log file as restricted then logs size will increase upto specified limit and then it will start discarding old logs and new logs will be there in logs.
- If we set autgrowth for log file as unrestricted the then it will grow until disk space is full.
Please help me to know if this assumption is correct and if it is wrong then please correct me.