Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SusanMem
Starting Member
1 Post |
 Posted - 2011-02-06 : 01:29:27
|
Dear SQL Team,When i want to fill my new table, following error appears:Msg 1105, Level 17, State 2, Line 1Could not allocate space for object 'dbo.CcAccCK_11'.'PK_CcAccCK_11' in database 'Finance' 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.  I've tried to reduce the size but i could not. Could you please help me to solve it? Thanks in advance. |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-02-06 : 07:24:31
|
You have to free up hard drive space or increase the allocated space to the database file group. If you have a specified size limit on the database, and there is available hard drive space...increase the size. If no available hard drive space...you will have to find some or make some by removing/deleting/compressing files.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2011-02-06 : 14:48:45
|
| Is Autogrowth Option Enabled?? Check it. |
|
|
|
|
|
|
Msg 1105