Sunday, March 11, 2012

Changing settings on a Database

We had to change the settings of both our database and transaction because
the database is growing enormously. Once we made the changes is a restart of
either the system or the services required?
--
___________________________
GiacomoWhat settings did you change?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Giacomo" <gdagostino@.vision2000.ca> wrote in message
news:8B28B334-2E45-4316-8EF9-686109B70A25@.microsoft.com...
> We had to change the settings of both our database and transaction because
> the database is growing enormously. Once we made the changes is a restart of
> either the system or the services required?
> --
>
> ___________________________
> Giacomo|||We set the both database and transaction logs ofr % growth!
"Tibor Karaszi" wrote:
> What settings did you change?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Giacomo" <gdagostino@.vision2000.ca> wrote in message
> news:8B28B334-2E45-4316-8EF9-686109B70A25@.microsoft.com...
> > We had to change the settings of both our database and transaction because
> > the database is growing enormously. Once we made the changes is a restart of
> > either the system or the services required?
> > --
> >
> >
> >
> > ___________________________
> > Giacomo
>|||Hi,
No need to restart the SQL Server after changing the database growth %. This
will come in to effect with out any action.
Thanks
Hari
SQL Server MVP
"Giacomo" <gdagostino@.vision2000.ca> wrote in message
news:29E91932-86CF-4494-BABF-ED911BAF42A4@.microsoft.com...
> We set the both database and transaction logs ofr % growth!
> "Tibor Karaszi" wrote:
>> What settings did you change?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Giacomo" <gdagostino@.vision2000.ca> wrote in message
>> news:8B28B334-2E45-4316-8EF9-686109B70A25@.microsoft.com...
>> > We had to change the settings of both our database and transaction
>> > because
>> > the database is growing enormously. Once we made the changes is a
>> > restart of
>> > either the system or the services required?
>> > --
>> >
>> >
>> >
>> > ___________________________
>> > Giacomo
>>

No comments:

Post a Comment