|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Urgent! Can't allocate space for object
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Urgent! Can't allocate space for object
|
|
| Raymond 2002-11-27, 9:23 pm |
| When I run a store pro to update and insert some tables
I get this message:
"Can't allocate space for object 'TBL_A' in database
'DB_A' because the 'default' segment is full. If you ran
out of space in Syslogs, dump the transaction log.
Otherwise, use ALTER DATABASE or sp_extendsegment to
increase the size of the segment."
I check the transaction log is empty. and the sp_spaceused
show that I still have more than enough space.
Your help is highly appreciated.
Raymond
| |
| Tibor Karaszi 2002-11-28, 4:23 am |
| Don't trust sp_spaceused. See the documentation for the DBCC UPDATEUSAGE command.
Also, if you read the error message, you see that the problem is not with the log, it is the
data. So, you need to expand the database (data) and not the log.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Raymond" <rcsh@hongkong.com> wrote in message
news:1bda601c2968b$898dfe40$89
f82ecf@TK2MSFTNGXA01...
> When I run a store pro to update and insert some tables
> I get this message:
> "Can't allocate space for object 'TBL_A' in database
> 'DB_A' because the 'default' segment is full. If you ran
> out of space in Syslogs, dump the transaction log.
> Otherwise, use ALTER DATABASE or sp_extendsegment to
> increase the size of the segment."
>
> I check the transaction log is empty. and the sp_spaceused
> show that I still have more than enough space.
>
> Your help is highly appreciated.
> Raymond
|
|
|
|
|