Lof - file grow

Question

Lof - file grow

river1

SSC-Insane

Points: 24309
More actions
April 20, 2010 at 8:00 am

#220630

Hi,
When i create a database in SQL Server 2005 the database don't let me change the log file to unristrited file grow, why? how can i change it?
Thank you.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Shabba SSCertifiable Points: 5007 More actions · Answer 1

river1 (4/20/2010)
Hi,
When i create a database in SQL Server 2005 the database don't let me change the log file to unristrited file grow, why? how can i change it?
Thank you.

Are you doing this within the GUI? Try the following tsql. Check BOL for parameters.

ALTER DATABASE [MyDB] MODIFY FILE ( NAME = N'MyDB_log', MAXSIZE =

UNLIMITED, FILEGROWTH = 10%)

river1 SSC-Insane Points: 24309 More actions · Answer 2

river1

SSC-Insane

Points: 24309

April 20, 2010 at 8:59 am

#1154651

Isn't there a way of doing it by the GUI

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

river1 (4/20/2010)
Isn't there a way of doing it by the GUI

When you say the GUI isn't letting you do this, can you explain it in more depth? What is occuring?

river1 SSC-Insane Points: 24309 More actions · Answer 4

If you create a new database and then go to the properties of the database, then right click on the Files and then on the AutoGrow (of the log file), you will see that when you try to put the Log file (max file grow) in unrestricted File Grow the GUI let's you do it, but when you save and see the properties again of the database, then the database did not change anything about the Log file. The log file is still in the restricted file grow option...

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

river1 (4/20/2010)
If you create a new database and then go to the properties of the database, then right click on the Files and then on the AutoGrow (of the log file), you will see that when you try to put the Log file (max file grow) in unrestricted File Grow the GUI let's you do it, but when you save and see the properties again of the database, then the database did not change anything about the Log file. The log file is still in the restricted file grow option...

Yes, and the max size is shown as 2,097,152 MB which happens to be 2 TB which happens to be the maximum size the log file can be. So, this is unlimited growth for the log file.