ERROR: "Could not allocate space for object 'X' in dabase 'Your Database' because the 'PRIMARY' filegroup is full"

“Could not allocate space for object ‘X’ in dabase ‘Your Datase’ because the ‘PRIMARY’ filegroup is full” error

You receive an error similar to: ‘Could not allocate space for object ‘X’ in dabase ‘Your Database’ 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 auto growth on for existing files in the filegroup.’ when browsing to your site.

Your database is either too big or had an artificial size limitation imposed on it by a previous host.

The following steps require Microsoft SQL Server Management Studio. If you do not have this installed on your local computer please follow the instructions at How To Connect to Your MS SQL 2008 Database and Disable Collation

  1. Open Microsoft SQL Server Management Studio.
  2. Right click [your database] and select Properties.
  3. In the left navigation window of the dialog box that pops up, select Files.
  4. In the Autogrowth column select the  button noted in the image below and change them it to Unrestricted Growth under Maximum File Size.

  5. Repeat step 4 for the second file type.
  6. Click OK

Leave a Comment

E-posta hesabınız yayımlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir

This site uses Akismet to reduce spam. Learn how your comment data is processed.