Should I enable autogrowth on SharePoint 2007 (WSS 3.0) with SQL 2005 Express Edition ?

Hi Folks,

My current WSS 3.0 (SHarePoint 2007) site is using the buildin SQL 2005 Express Edition.

Should I enable or disable the autogrowth for the WSS_Search database and log files by unctick-ing the checkboxes ?

or shouldI set the upper maximum limit in the initial size ?
LVL 13
Senior IT System EngineerSenior Systems EngineerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott PletcherSenior DBACommented:
Definitely enable autogrowth, just in case, particularly for the log.  If a log file fills up, the database will stop (almost) all activity until that's resolved.

But you should monitor the space yourself and pre-allocate space before it's needed if possible.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Senior IT System EngineerSenior Systems EngineerAuthor Commented:
Scott.

so in this case with SQL Express DB, where can I set the DB maximum to be 4 GB and the Log file to be 20 MB only to prevent the log files taking the drive space ?
Scott PletcherSenior DBACommented:
You can right-click on the db, then "Properties", then "Files", then "Autogrowth" -- you also set the max size within the Autogrowth area.
Get Blueprints for Increased Customer Retention

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

Senior IT System EngineerSenior Systems EngineerAuthor Commented:
Scott, what happens when I uncheck the Autogrowth option on both DB and Logs ?
Scott PletcherSenior DBACommented:
Then Autogrow would be disabled; instead of the db automatically adding space, you would get an error msg and the command(s) involved would fail.  If it's a log file, all activity on the db would fail until the log file issue is corrected.
Senior IT System EngineerSenior Systems EngineerAuthor Commented:
ok, so in this case when the autogrowth is disabled (unchecked), then I will have to max out the value in the "initial size" column to be:

Database .mdf --> 4000 MB
Logs .ldf ---> 4000 MB just to be safe

is that make sense just to reduce the overhead in the autogrow-ing the logs and the DB ?
Justin SmithSr. System EngineerCommented:
With Express, it's better to not enable autogrowth on the data file.  Just pre-size it to 4 GB.

You want the Log to grow as needed, 100 MB at a time is a good choice for most people.

However you need to decide what to set the recovery mode to on the database, simple or full.  If you don't plan on running any type of incremental backups, set the recovery mode to simple.  This will prevent your log from growing out of control.
Justin SmithSr. System EngineerCommented:
I'm talking about your main content database only, by the way.  Don't pre-set every database to 4 GB, just the content db.  The others should be allowed to auto-grow as necessary.  Again, 100 MB is a good choice here.
Senior IT System EngineerSenior Systems EngineerAuthor Commented:
Thanksfor the calrificartion

however, the WSS_Content DB is not accessible, only the WSS_Search that I can manipulate around.
Justin SmithSr. System EngineerCommented:
Have you already hit the size limit?
Senior IT System EngineerSenior Systems EngineerAuthor Commented:
No i'm not hitting the upper limit 4 GB yet on the wss_search database in my SQL Express Edition.
Justin SmithSr. System EngineerCommented:
I'm talking about WSS_Content.  How big is the data file and log together?
Senior IT System EngineerSenior Systems EngineerAuthor Commented:
The content is 19 GB but on different SQL server DB
Justin SmithSr. System EngineerCommented:
Ok, well with the Search database, I wouldn't probably wouldn't set the size to 4 GB as it likely won't ever get that big if you only have 19 GB of content.  I would just set it to auto grow by 100 MB.  My comments for the recovery model still hold true.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.