Filegroup Space Issues

I can see the below error in the Event viewer and the SQL Server 2008 Express seem to be timing out when trying to login:

"Could not allocate space for object 'dbo.VerboseLogs'.'PK_Logs' in database 'XXXXX' 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."

Any Ideas? There is plenty of space available on the drive. Also, Log file is set to Autogrow by 10 percent, restricted growth till 2,097,152 MB. MDF is set to Autogrow by 1 MB, unrestricted growth.

more ▼

asked Feb 22, 2010 at 09:46 AM in Default

avatar image

Sagar Bhargava
638 26 30 34

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Yes, SQL Server Express is limited to 4GB... so you can't exceed that limit no matter how much space you have on the disk.

If you want to have a look at how the space is used, and drill down, then try out my tool for that.

more ▼

answered Feb 22, 2010 at 09:56 AM

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

  • for ability to plug product shamelessly ;)

Feb 22, 2010 at 10:54 AM Fatherjack ♦♦

:) All the products are available free, so I don't feel guilty! Plus I only link to them where it's 100% relevant, and I always include links to the Red Gate / Apex equivalents where there are any... So yeah, guilt factor = 0.

Feb 22, 2010 at 11:00 AM Matt Whitfield ♦♦

Its a good tool! Anyway, now may be a good time to look at SQL Server 2008 Standard. If that is not an option, consider splitting the data into multiple databases.

Feb 22, 2010 at 02:35 PM TimothyAWiseman

agreed a very good tool, I use it and am pleased with the view it gives me. Sometimes pictures/images show the details more quickly than a screen full of numbers.

Feb 22, 2010 at 03:26 PM Fatherjack ♦♦

Thanks guys :) glad you like it...

Feb 22, 2010 at 04:30 PM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left

How big is the log file on the hard drive, has it reached the 2GB limit?

more ▼

answered Feb 22, 2010 at 09:57 AM

avatar image

Fatherjack ♦♦
43.8k 79 102 118

I have shrinked this log file as a means to create some space as this is not a heavily used production box. Can this issue cause Timeout issue during login to Management Studio. I noticed server team has installed Sophos Antivirus on this box. I have heard AV causing issues with DB servers.

Feb 22, 2010 at 10:14 AM Sagar Bhargava

if the log file was full then no database activity would take place. Do you have regular jobs to backup the database? You may be able to switch to SIMPLE recovery mode to reduce the entries being stored in the logfile.

Feb 22, 2010 at 10:56 AM Fatherjack ♦♦

Can a space issue with one filegroup of a database cause a timeout during login to Management Studio?

Feb 23, 2010 at 02:56 AM Sagar Bhargava

the fact is that the logfile was unable to log any database activity so would not allow connections. this needs to be managed, either by no logging EVERY transaction (ie SIMPLE recovery mode) or making more room. You could add extra logfiles (mylogfile.ndf) up to the maximum size of a SQLExpress database as mentioned by Matt. You also need to run regular backups in order to keep the logfile at a manageable size, whatever other options you choose.

Feb 23, 2010 at 06:54 AM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Feb 22, 2010 at 09:46 AM

Seen: 3233 times

Last Updated: Feb 22, 2010 at 09:46 AM

Copyright 2018 Redgate Software. Privacy Policy