Could not attach database, can't allocated object

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

SQL Server 2000 Forums

SQL Server Administration (2000)

Could not attach database, can't allocated object

Author

Topic

r1ck_kl
Starting Member

4 Posts

Posted - 2007-07-16 : 23:41:26

Hi all,

i have a problem that couldn't attach database,
error message occurs "Could not allocated space for object 'tb_count' in database 'db_control' because the 'Default' filegroup is full".

can anyone help me about this problem. I'm new on SQL thanks.
very appreciated for your feedback.

Rgds,
r1ck

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-07-16 : 23:46:40

Check your hard disk available space

KH
[spoiler]Time is always against us[/spoiler]

r1ck_kl
Starting Member

4 Posts

Posted - 2007-07-16 : 23:58:38

KH, still got 50 GB free space

Rgds,
r1ck

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-07-17 : 00:13:40

Is the database set to automatic file growth ?

use Enterprise Manager, check the properties of the database, on the Data Files tab page.

KH
[spoiler]Time is always against us[/spoiler]

r1ck_kl
Starting Member

4 Posts

Posted - 2007-07-17 : 00:17:51

KH, thanks for your quick reply, but problem is currently i can't attach the database on the enterprise manager, so how come can i check the properties on it ? is there other ways to check the properties ?

Rgds,
r1ck

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-07-17 : 00:27:26

How big is your database, data & log ?
Where is the data & log located ?

Do you have sufficient space on disk for the data & log file ?

KH
[spoiler]Time is always against us[/spoiler]

r1ck_kl
Starting Member

4 Posts

Posted - 2007-07-17 : 00:32:39

Data = db_control.mdf size 2GB
Log = db_control_log.ldf size 9,2MB
located on c:\program files\data
free HDD space on root C = 50 GB

Rgds,
r1ck

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-17 : 13:26:04