It can be set up to auto grow or not. It also can (should) have an upper limit. Even if you have it set up autogrow, if it can't grow in the amount of space needed, then it will repost as full. I set my database up to grow by MB, not by percent also (% growth will increase as the DB grows).
I normally cap all databases (not includid system DBs) and tempdb. Set growth to auto, and the MB of growth to either 50 or 100 mb (Depending on the DB). 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: Schreck, Tom 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]] 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. -----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
