SQL and Space available - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL and Space available

Author

Topic

alimuumin
Starting Member

7 Posts

Posted - 2005-09-07 : 00:21:54

I have a database with almost 3 tables each contains atleast 1 million Rows, and My hard disk space is 14G.

I want to insert another table some queries i have selected from different tables.

I got this Error:

(254118 row(s) affected)

(935885 row(s) affected)

Server: Msg 1105, Level 17, State 2, Procedure sp_ProcessRowData, Line 68
Could not allocate space for object 'Processed_Data' in database 'Mydb' because the 'PRIMARY' filegroup is full.

Any Help............

Regards Mr. Mumin
Thanks All,

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-09-07 : 00:39:15

Look at EXEC sp_helpdb 'dbname' and see what your maxsize is set to.

Also, google it. There are about 200 trillion articles on this.

http://www.google.com/search?hl=en&lr=&q=Could+not+allocate+space+for+object+because+the+%27PRIMARY%27+filegroup+is+full.&btnG=Search

Let me know what the maxsize is when you run that command.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

alimuumin
Starting Member

7 Posts

Posted - 2005-09-07 : 00:57:20

quote:
Look at EXEC sp_helpdb 'dbname' and see what your maxsize is set to.
Let me know what the maxsize is when you run that command.

The Maximum Size is Unlimited and the Database size(db_size) is 3848.06 MB
But the Primary File Group size is 3846144 KB

Regards Mr. Mumin
Thanks All,

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2005-09-07 : 06:56:40

but what disk drive is the primary located upon....(and the temp db as well)....is there any more room on this disk???

MichaelP
Jedi Yak

2489 Posts

Posted - 2005-09-07 : 08:59:30

What version of SQL Server are you using?

Do a SELECT @@Version

Michael

<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>

snipeg
Starting Member

1 Post

Posted - 2005-12-22 : 08:12:47

Hi guys, well about the error. Check that you have enough space in te harddisk where the db is allocated. If you don`t, there is the problem.

mr_mist
Grunnio

1870 Posts

Posted - 2005-12-22 : 09:15:00

What's the growth increment set to? There is probably not enough space for it to grow. Is the autogrow option enabled?

-------
Moo. :)

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2005-12-22 : 11:30:09

It's amazing that a 3 month old problem can be resurrected...by a repeat of advice already given.!

mr_mist
Grunnio

1870 Posts

Posted - 2005-12-23 : 03:49:05

Always nice to raise things from the dead. Must admit I didn't notice the date. Still, maybe the project is still going ;)

-------
Moo. :)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources