Database Setting - File Growth

Hi,
What will happen or what should a database administrator do if the setting
for file growth for a database and log file is not automatic growth?
Monitor free space and before nearing full increase the size of the relevant files (ALTER DATABASE
... MODIFY FILE...).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Alice" <Alice@.discussions.microsoft.com> wrote in message
news:6329BF3B-A9E3-4F8A-989F-717103397012@.microsoft.com...
> Hi,
> What will happen or what should a database administrator do if the setting
> for file growth for a database and log file is not automatic growth?
|||Hello,
Like Tibor mentioned you may need to monitor the MDF and LDF files closely
if the file size is not to set automatic growth.
But my best recommendation is create the MDF and LDF size with required size
and make sure that auto growth not happends as well as
you can make the auto growth option enabled. THis will help you not having
any downtime due to lack of database space...
Thanks
Hari
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23PFEXm1qHHA.3492@.TK2MSFTNGP02.phx.gbl...
> Monitor free space and before nearing full increase the size of the
> relevant files (ALTER DATABASE ... MODIFY FILE...).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Alice" <Alice@.discussions.microsoft.com> wrote in message
> news:6329BF3B-A9E3-4F8A-989F-717103397012@.microsoft.com...
>
|||1) DO NOT EVER let a production database keep the default size and
especially growth increments for either the data OR log file!!! You will
quickly get extremely fragmented os files (for any reasonable amount of data
size) that will significantly affect performance of the database.
2) I advise my clients to estimate their data growth needs for at least 1
year out and set the database/log size appropriate for that to avoid any
growth and also to leave relatively large blocks of empty space so sql
server can lay data down contiguously (esp. during maintenance) - thus
leading to much better disk I/O performance.
3) Set autogrowth on and some reasonable MB or percentage growth factor
depending on size and growth patterns.
TheSQLGuru
President
Indicium Resources, Inc.
"Alice" <Alice@.discussions.microsoft.com> wrote in message
news:6329BF3B-A9E3-4F8A-989F-717103397012@.microsoft.com...
> Hi,
> What will happen or what should a database administrator do if the setting
> for file growth for a database and log file is not automatic growth?

Database Setting - File Growth

Hi,
What will happen or what should a database administrator do if the setting
for file growth for a database and log file is not automatic growth?Monitor free space and before nearing full increase the size of the relevant files (ALTER DATABASE
... MODIFY FILE...).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Alice" <Alice@.discussions.microsoft.com> wrote in message
news:6329BF3B-A9E3-4F8A-989F-717103397012@.microsoft.com...
> Hi,
> What will happen or what should a database administrator do if the setting
> for file growth for a database and log file is not automatic growth?|||Hello,
Like Tibor mentioned you may need to monitor the MDF and LDF files closely
if the file size is not to set automatic growth.
But my best recommendation is create the MDF and LDF size with required size
and make sure that auto growth not happends as well as
you can make the auto growth option enabled. THis will help you not having
any downtime due to lack of database space...
Thanks
Hari
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23PFEXm1qHHA.3492@.TK2MSFTNGP02.phx.gbl...
> Monitor free space and before nearing full increase the size of the
> relevant files (ALTER DATABASE ... MODIFY FILE...).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Alice" <Alice@.discussions.microsoft.com> wrote in message
> news:6329BF3B-A9E3-4F8A-989F-717103397012@.microsoft.com...
>> Hi,
>> What will happen or what should a database administrator do if the
>> setting
>> for file growth for a database and log file is not automatic growth?
>|||1) DO NOT EVER let a production database keep the default size and
especially growth increments for either the data OR log file!!! You will
quickly get extremely fragmented os files (for any reasonable amount of data
size) that will significantly affect performance of the database.
2) I advise my clients to estimate their data growth needs for at least 1
year out and set the database/log size appropriate for that to avoid any
growth and also to leave relatively large blocks of empty space so sql
server can lay data down contiguously (esp. during maintenance) - thus
leading to much better disk I/O performance.
3) Set autogrowth on and some reasonable MB or percentage growth factor
depending on size and growth patterns.
--
TheSQLGuru
President
Indicium Resources, Inc.
"Alice" <Alice@.discussions.microsoft.com> wrote in message
news:6329BF3B-A9E3-4F8A-989F-717103397012@.microsoft.com...
> Hi,
> What will happen or what should a database administrator do if the setting
> for file growth for a database and log file is not automatic growth?

Database Setting - File Growth

Hi,
What will happen or what should a database administrator do if the setting
for file growth for a database and log file is not automatic growth?Monitor free space and before nearing full increase the size of the relevant
files (ALTER DATABASE
... MODIFY FILE...).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Alice" <Alice@.discussions.microsoft.com> wrote in message
news:6329BF3B-A9E3-4F8A-989F-717103397012@.microsoft.com...
> Hi,
> What will happen or what should a database administrator do if the setting
> for file growth for a database and log file is not automatic growth?|||Hello,
Like Tibor mentioned you may need to monitor the MDF and LDF files closely
if the file size is not to set automatic growth.
But my best recommendation is create the MDF and LDF size with required size
and make sure that auto growth not happends as well as
you can make the auto growth option enabled. THis will help you not having
any downtime due to lack of database space...
Thanks
Hari
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23PFEXm1qHHA.3492@.TK2MSFTNGP02.phx.gbl...
> Monitor free space and before nearing full increase the size of the
> relevant files (ALTER DATABASE ... MODIFY FILE...).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Alice" <Alice@.discussions.microsoft.com> wrote in message
> news:6329BF3B-A9E3-4F8A-989F-717103397012@.microsoft.com...
>|||1) DO NOT EVER let a production database keep the default size and
especially growth increments for either the data OR log file!!! You will
quickly get extremely fragmented os files (for any reasonable amount of data
size) that will significantly affect performance of the database.
2) I advise my clients to estimate their data growth needs for at least 1
year out and set the database/log size appropriate for that to avoid any
growth and also to leave relatively large blocks of empty space so sql
server can lay data down contiguously (esp. during maintenance) - thus
leading to much better disk I/O performance.
3) Set autogrowth on and some reasonable MB or percentage growth factor
depending on size and growth patterns.
TheSQLGuru
President
Indicium Resources, Inc.
"Alice" <Alice@.discussions.microsoft.com> wrote in message
news:6329BF3B-A9E3-4F8A-989F-717103397012@.microsoft.com...
> Hi,
> What will happen or what should a database administrator do if the setting
> for file growth for a database and log file is not automatic growth?

Database Replication

Hello all,
I am looking for a "beginners guide" on setting up the automatic (daily)
replication of a production database to an identical database on another
server. This second database is to be used for training purposes. This is
for MSSQL 2000.
I have a customer that wishes to do this, and rather than explain it all I
would rather point him to a guide that he can look at (pleanty of pictures
would be good) and then ask questions if necessary.
Does anyone know of such a thing that is accessible?
Thank you in advance.
Jon Hunt
IT Manager
You might want to direct your customer to this -
http://www.mssqlcity.com/Articles/Re...TR/SetupTR.htm
There is some nonsense in here, but its ok. This is for SQL 7, but it is
much the same for SQL 2000.
"Jon Hunt" <thisisnotmyaddress@.nospam.invalid> wrote in message
news:Xns9578844C8F373softworks@.158.152.254.254...
> Hello all,
> I am looking for a "beginners guide" on setting up the automatic (daily)
> replication of a production database to an identical database on another
> server. This second database is to be used for training purposes. This is
> for MSSQL 2000.
> I have a customer that wishes to do this, and rather than explain it all I
> would rather point him to a guide that he can look at (pleanty of pictures
> would be good) and then ask questions if necessary.
> Does anyone know of such a thing that is accessible?
> Thank you in advance.
> --
> Jon Hunt
> IT Manager