Enabling file growth

I am trying to keep my log file at unrestricted file growth, but every time
I save the settings it switches back to restricted growth with a default
file size. I tried to keep it restricted, and change the size llimit, but
it changed back to it'd default limit. Why is this changing automaically by
itself.
I want to keep file growth enabled at 5% with unrestricted growth, but it
keeps changing back to 5% and resticted file growth with a default size. I
don't understand why it changes!!!!
ALTER DATABASE [database_name] MODIFY FILE ( NAME = 'file_name',
FILEGROWTH = 5%)
What do you get when you run the above statement with your
database_name and file_name changed?
On Jun 14, 9:35 am, "Matt Fritz" <mafr...@.state.pa.us> wrote:
> I am trying to keep my log file at unrestricted file growth, but every time
> I save the settings it switches back to restricted growth with a default
> file size. I tried to keep it restricted, and change the size llimit, but
> it changed back to it'd default limit. Why is this changing automaically by
> itself.
> I want to keep file growth enabled at 5% with unrestricted growth, but it
> keeps changing back to 5% and resticted file growth with a default size. I
> don't understand why it changes!!!!
On Jun 14, 9:35 am, "Matt Fritz" <mafr...@.state.pa.us> wrote:
> I am trying to keep my log file at unrestricted file growth, but every time
> I save the settings it switches back to restricted growth with a default
> file size. I tried to keep it restricted, and change the size llimit, but
> it changed back to it'd default limit. Why is this changing automaically by
> itself.
> I want to keep file growth enabled at 5% with unrestricted growth, but it
> keeps changing back to 5% and resticted file growth with a default size. I
> don't understand why it changes!!!!
|||On 14 Jun, 14:35, "Matt Fritz" <mafr...@.state.pa.us> wrote:
> I am trying to keep my log file at unrestricted file growth, but every time
> I save the settings it switches back to restricted growth with a default
> file size. I tried to keep it restricted, and change the size llimit, but
> it changed back to it'd default limit. Why is this changing automaically by
> itself.
> I want to keep file growth enabled at 5% with unrestricted growth, but it
> keeps changing back to 5% and resticted file growth with a default size. I
> don't understand why it changes!!!!
Why do you want to grow the log at 5%? Log growth is something you
should try to avoid. My advice is to set it to a sufficient size so
that it won't grow.
If you need more help, please post the actual ALTER statements you
ran. Don't rely on the management tools to do it correctly for you.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx