x

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

Sagar Bhargava gravatar image

Sagar Bhargava
358 24 25 27

(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

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.5k 61 65 87

+1 - 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

Fatherjack gravatar image

Fatherjack ♦♦
42.8k 75 79 108

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x32
x22

asked: Feb 22, 2010 at 09:46 AM

Seen: 3027 times

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