Re: question about autogrowth and shrinkfile
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Sun, 30 Mar 2008 15:30:16 -0700
geekyguy (geeky@xxxxxxx) writes:
But say that the database had been running like that for a fortnight.
It was longer than that...several months...
Oops! Assuming that you also left out the full backup, you are lucky that
something bad didn't happen in that period.
So if I become more proactive and really track the growth, as well as
maintain regular backups of the transaction log (hourly?), if it's only
growing at say 200 meg/day max, I could fix it's size at 1 gig and not
worry about it? I will probably leave auto-grow on just to be safe, but
I want to make sure I understand the sizing issues.
1 GB sounds right.
Yes, leave auto-grow on. Even if auto-grow should ideally not happen
when the system is up, it's a lot better than the system grinding to
a total standstill because of a full file.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- question about autogrowth and shrinkfile
- From: geekyguy
- Re: question about autogrowth and shrinkfile
- From: Erland Sommarskog
- Re: question about autogrowth and shrinkfile
- From: geekyguy
- question about autogrowth and shrinkfile
- Prev by Date: RE: How to add a server conn in business Intelligence Development Stud
- Next by Date: RE: How to add a server conn in business Intelligence Development Stud
- Previous by thread: Re: question about autogrowth and shrinkfile
- Next by thread: How to add a server conn in business Intelligence Development Stud
- Index(es):
Relevant Pages
|
