I dont understand why did i get this error.
00:2003/08/14 03:53:18.42 server Error: 1105, Severity: 17, State: 4
00:2003/08/14 03:53:18.42 server Can't allocate space for object
'syslogs' in database 'netreal' because the 'logsegment' 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.
00:2003/08/14 03:53:18.44 server Unable to write CHECKPOINT record in
database 5 because the log is out of space.
00:2003/08/14 03:53:18.44 server Automatic checkpointing is disabled
in database 'netreal' because the log is out of space. It will
continue when the DBO successfully checkpoints the database. Please
free up some space or extend the database and then run CHECKPOINT.
00:2003/08/14 03:53:27.82 server WARNING: ***************************
00:2003/08/14 03:53:27.82 server Attempt by user 3 to dump xact on db
netreal with NO_LOG
00:2003/08/14 03:56:24.32 server WARNING: ***************************
00:2003/08/14 03:56:24.32 server Attempt by user 3 to dump xact on db
netreal with NO_LOG
00:2003/08/14 03:59:24.81 server WARNING: ***************************
00:2003/08/14 03:59:24.82 server Attempt by user 3 to dump xact on db
netreal with NO_LOG
00:2003/08/14 04:02:26.91 server WARNING: ***************************
00:2003/08/14 04:02:26.92 server Attempt by user 3 to dump xact on db
netreal with NO_LOG
00:2003/08/14 04:05:26.35 server WARNING: ***************************
00:2003/08/14 04:05:26.36 server Attempt by user 3 to dump xact on db
netreal with NO_LOG
00:2003/08/14 04:08:34.61 server WARNING: ***************************
00:2003/08/14 04:08:34.62 server Attempt by user 3 to dump xact on db
netreal with NO_LOG
00:2003/08/14 04:11:29.94 server WARNING: ***************************
00:2003/08/14 04:11:29.94 server Attempt by user 3 to dump xact on db
netreal with NO_LOG
00:2003/08/14 04:14:32.15 server WARNING: ***************************
00:2003/08/14 04:14:32.16 server Attempt by user 3 to dump xact on db
netreal with NO_LOG
00:2003/08/14 04:17:32.32 server WARNING: ***************************
00:2003/08/14 04:17:32.32 server Attempt by user 3 to dump xact on db
netreal with NO_LOG
00:2003/08/14 04:20:27.58 server WARNING: ***************************
00:2003/08/14 04:20:27.61 server Attempt by user 3 to dump xact on db
netreal with NO_LOG
00:2003/08/14 04:22:53.24 server Attempt by user 3 to dump xact on db
netreal with NO_LOG was successful
00:2003/08/14 04:22:53.26 server WARNING: ***************************
00:2003/08/14 07:08:03.49 server Error: 1601, Severity: 21, State: 3
00:2003/08/14 07:08:03.53 server There are not enough 'user
connections' available to start a new process. Retry when there are
fewer active users, or ask your System Administrator to reconfigure
SQL Server with more user connections.
00:2003/08/14 07:08:06.57 server Error: 1601, Severity: 21, State: 3
I see no reason to think there may be a hidden problem
behind this. I've seen 1601 errors many times and the
reason was always a lack of free connections.
Regards,
Mariano Corral
To check the current number of connections log in as 'sa' and issue this command in isql:
sp_configure 'user connections'
go
To allocate 40 more connections use this command:
sp_configure 'user connections', 40
go
--Roy Stewart
On 31 Aug 2003 07:36:54 -0700, ofer...@allot.com (ofer) wrote:
> look at the last line in the error log: 00:2003/08/14 07:08:06.57
> server Error: 1601, Severity: 21, State: 3
>
> I dont understand why did i get this error.
>
>
>