Solved

PRIMARY filegroup is full   SQL Server 2005

Posted on 2010-11-10
4
883 Views
Last Modified: 2012-05-10
Hi

This is an error message in my prod environment.  
Can somebody give me the steps to resolving the following problem?


Executed as user: NT AUTHORITY\SYSTEM.
Could not allocate space for object 'dbo.ePetlm_Index' in database 'MCS'
because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. [SQLSTATE 42000] (Error 1105).  The step failed


thanks
0
Comment
Question by:Favorable
  • 2
4 Comments
 
LVL 3

Accepted Solution

by:
DFW_Ed earned 250 total points
ID: 34104814
What disk space is left or available where it resides?
If none, is it virtual so you can easily add more or is it a physical drive?  
How big is the filegroup?  (to determine length and difficulty of potentially moving)
Are there log files shared on that drive that can be easily backed up, truncated and even better moved?
0
 
LVL 9

Assisted Solution

by:damerval
damerval earned 250 total points
ID: 34104903
Hi,
I'm assuming you checked the obvious, such as whether your server is out of disk space?
Please review the following link for information on file groups:
http://msdn.microsoft.com/en-us/library/ms179316.aspx

Meanwhile, if the error is not a result of lack of physical disk space, then it would seem you need to create a new filegroup or allow your file group to grow automatically. This is described on the following section:
http://technet.microsoft.com/en-us/library/bb522469.aspx

Generally, run an ALTER DATABASE statement either specifying a new file that auto-grows or adding a new filegorup containing a file that auto-grows. Remember, a filegroup does not really exist - it is a logical object created purely to help compartmentalize the way your database is stored physically. In the end your database is stored on individual files, primary and secondary data files as well as log files. You choose where you want to store your tables physically when you define your tables (and other objects). It is very useful to plan for this when you need to grow your database, for instance, you want want to put large tables in one place and tables that are accessed very often for micro-results in another, thus achieving better management of your I/O, which typically is the bottleneck on a database server.

Thx,

Philippe
0
 

Author Comment

by:Favorable
ID: 34136501
Was resolved by disabled the auto growth for few seconds and enabled after few seconds.
0
 

Author Closing Comment

by:Favorable
ID: 34136512
Nice comments
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server 208R2 not recognizing DBF file in linked Server 11 60
Email Notifications for SQL 2005 9 35
Find results from sql within a time span 11 45
tempdb log keep growing 7 33
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question