SQLUSA
FREE TRIAL  CLICK HERE TO ORDER  SEARCH
SQL Server 2008 Training Scripts
SQL Server 2005 Training Scripts
SQL Server Training Scripts
SQL 2008 GRAND SLAM
How to resolve PRIMARY filegroup full error?

When the database runs of disk space on the default filegroup the following error message sent:

"Could not allocate space for object 'TableName' in database 'DatabaseName' because the 'PRIMARY' filegroup is full"

Options to resolve the error:

1. Add one or more files to the PRIMARY filegroup

2. Shrink database (DBCC SHRINKDATABASE)

3. Shrink database file(s) (DBCC SHRINKFILE)

 

The World Leader in SQL Server 2008 Training
Order SQL 2008 GRAND SLAM Today!
The Future is just a CLICK away! Your Future!
SQLUSA.com Home Page

Copyright 2005-2010, SMI Corp. All Rights Reserved.

SQL Server 2008 is a program product of Microsoft Corporation.
SQL Server 2005 is a program product of Microsoft Corporation.
SQL Server 2000 is a program product of Microsoft Corporation.