When you're creating a new db in EM the file properties default to "automatically grow file" (checkbox) "by percent 10%" and with maximum file size "unrestricted file growth". These properties are also configurable after the fact in your db properties in EM, under the Data Files tab.
FYI, this is also one of the requirements for the service-packs for sql7/2000 that you have to make sure your master db is set to automatically grow with unrestricted file groth before you attempt the service pack install, otherwise the potential exists for the installation to fail half-way through by running out of available storage space. hth Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 > I thought the databases would grow automatically by a certain percent as > the size of the DB starts to reach its limit. Am I mistaken, or is this > a manual process to increase the size? > Thanks - > Tom Schreck > 817-252-4900 > [EMAIL PROTECTED] > I have not failed. I've found 10,000 ways that won't work. > - Thomas Edison > -----Original Message----- > From: David L. Penton [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 11, 2002 9:16 AM > To: [EMAIL PROTECTED] > Subject: RE: Strange error message > Your database growth has exceeded the limits set for the database. > Right > click the DB in EM, properties, then check the sizes. You may need to > increase the size (you can do it there). > The PRIMARY filegroup is basically a logical device that all the > database > objects reside on. You can have multiple filegroups, and you can have > objects that span multiple filegroups. > David L. Penton, Microsoft MVP > JCPenney Application Specialist / Lead > "Mathematics is music for the mind, and Music is Mathematics for the > Soul. - J.S. Bach" > [EMAIL PROTECTED] > Do you have the VBScript Docs or SQL BOL installed? If not, why not? > VBScript Docs: http://www.davidpenton.com/vbscript > SQL BOL: http://www.davidpenton.com/sqlbol > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of > Dave Livingston > Are you out of space on the HD that your DB file sits on? How much space > did > you allocate to that DB? > See if that may be your troubles. > Dave > David Livingston > Network Admin > 214-871-9117 > [EMAIL PROTECTED] > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On > Behalf > Of Schreck, Tom > Does any one know what the 'PRIMARY' filegroup is? It's not a field in > the > CDATA table. > ODBC Error Code = 37000 (Syntax error or access violation) > [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space > for > object 'CDATA' in database 'EAPubs' because the 'PRIMARY' filegroup is > full > Thanks - > Tom Schreck > 817-252-4900 > [EMAIL PROTECTED] > I have not failed. I've found 10,000 ways that won't work. > - Thomas Edison > ------------------------------------------------------------------------ > - > This email server is running an evaluation copy of the MailShield anti- > spam software. Please contact your email administrator if you have any > questions about this message. MailShield product info: > www.mailshield.com > ----------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To subscribe / unsubscribe: http://www.dfwcfug.org > ------------------------------------------------------------------------- > This email server is running an evaluation copy of the MailShield anti- > spam software. Please contact your email administrator if you have any > questions about this message. MailShield product info: www.mailshield.com > ----------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To subscribe / unsubscribe: http://www.dfwcfug.org ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
