Skip to Content (Press Enter)
OutSystems.com
Personal Edition
Community
Support
Training
Training
Online Training
Developer Schools
Boot Camps
Certifications
Tech Talks
Documentation
Documentation
Overview
ODC
O11
Forums
Forge
Get Involved
Get Involved
Jobs
Ideas
Members
Mentorship
User Groups
Platform
Platform
ODC
O11
Search in OutSystems
Log in
Get Started
Back to Forums
Julius Dickens
18
Views
5
Comments
SQL primary filegroup full!!
Question
Hi All:
I am getting this message when I try to compile my espace. It says that the primary filegroup is full. I have plenty of space left in my C Drive. Can someone give me the step by step to set the autogrow to on for the 2005 SQL version that comes with the community version of outsystems? Im desperate here.
Julius
David Nunes
Hi Julius,
You can select the database properties
And on the Files page select the data file and choose unrestricted growth.
If it's already unrestricted maybe you've hit the Sql Server 2005 Expres limit of 4Gb per database. More info
here
at the end of the page.
You can check database size on the General page of the database properties:
Let us know if this helped.
Best Regards
David Nunes
AcacioPN
Staff
You can also check this post for further help:
www.outsystems.com/forums/discussion/9539/sql-server-database-error-primary-filegroup-is-full/
vishal choksi
Hi devid
its working for me when i done this change in my database,but my company has 100 branches and all database have same problem but if i do this changes on all database is that gonna harm my head office server
or it will be have any problem
Miguel João
Staff
Hello Vishal
Usually the transaction log growth is something that can growth if uncheck, so I recommend properly setup maintenance plans to control the size of the transaction logs.
For instance:
Non-production environments should be configured to use Simple Recovery model, instead of Full Recovery model. More info on
https://msdn.microsoft.com/en-us/library/ms189275(v=sql.105).aspx
Production environment, should have regular transaction log backups to control the growth of the transaction log, and eventually, some regular shrinking of the transaction log file. More information about SQL Server best practices available at
www.outsystems.com/goto/sql-server-best-practices
If the problem is the database data files, then you need to size your databases according to the estimated data growth rate. If you're hitting on the 4GB database limit of SQL Server Express 2005 or 2008, then you either reduce the database set, or have to get some SQL Server licenses ...
Hope this helps to define an approach for large number of database instances.
Cheers
Miguel Simões João
vishal choksi
Thanks Miguel but one another problem i am facing when i go for sp_spaceused for my database its shows me negative figure in the unallocated space field
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
See the full guidelines
Loading...