SQL 7 Error Message: Error: 1105, Severity : 17, State 2 
Author Message
 SQL 7 Error Message: Error: 1105, Severity : 17, State 2

I received the following error message on a SQL 7 system:

 Error: 1105, Severity : 17, State 2
  Can't allocate space for object '%.*s' in database '%.*s' because
the
  '%.*s' 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 know this could happen on SQL 6.5, see Technet Article #Q152354, PSS
ID Number: Q152354, Article last modified on 02-14-2001.

My concern is that I'm seeing this on a SQL 7 database.  Is this still
a problem with SQL 7?  Is there a stored procedure I need to create
and execute to take care of this issue as this is a recurring problem
and just expanding the database/log does not fix this permanently.

Thanks-Derrick



Mon, 16 Aug 2004 23:29:03 GMT
 SQL 7 Error Message: Error: 1105, Severity : 17, State 2

Derrick, do you have the 'auto grow' option turned on for this database? If
not, turn it on, and you will not see this problem.

If you do have 'auto grow' turned and still seeing this error, then probably
you are out of disk space.
--
HTH,
Vyas, MVP (SQL Server)

http://vyaskn.tripod.com/


Quote:
> I received the following error message on a SQL 7 system:

>  Error: 1105, Severity : 17, State 2
>   Can't allocate space for object '%.*s' in database '%.*s' because
> the
>   '%.*s' 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 know this could happen on SQL 6.5, see Technet Article #Q152354, PSS
> ID Number: Q152354, Article last modified on 02-14-2001.

> My concern is that I'm seeing this on a SQL 7 database.  Is this still
> a problem with SQL 7?  Is there a stored procedure I need to create
> and execute to take care of this issue as this is a recurring problem
> and just expanding the database/log does not fix this permanently.

> Thanks-Derrick



Tue, 17 Aug 2004 00:28:47 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Error : 1105, Severity: 17, State: 1 when running Weekly Automated Maintenance in SQL Server 6.5

2. Error 1105/Severity 17/State 2 (SQL 6.5)

3. Error: 1105, Severity: 17, State:2

4. Error 1105, Severity: 17, State: 2

5. DataFiles and filegroups: Error: 1105, Severity: 17, State: 2

6. MSG 1105, Level 17, State 1 - error ...

7. cannot start server - error 1105, sev 17, state 2

8. Problem with SQL 7.0 Error: 17803, Severity: 17, State: 3

9. ERROR 9002, Severity 17, State 6

10. tempdb log full - Error: 9002, Severity: 17, State: 2

11. Error 9002, Severity:17 State:2

12. Msg 1105, Level 17, State 1


 
Powered by phpBB® Forum Software