cancel
Showing results for 
Search instead for 
Did you mean: 

set Automatic growth

Former Member
0 Kudos

Hi all,

I need to set in my SQL Server Automatic Growth for LOG file, but when I change the value in Enterprise Manager I can't save the new value.

How can I do?

Thanks.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

ok.

I have set the new state.

Thanks.

Former Member
0 Kudos

Hi,

have you tried to do it in TSQL yet?

use master

go

alter database [tempdb] MODIFY FILE ( NAME = N'tempdev', FILEGROWTH = 10%)

go

Did it work?

Regards,

Sven