i cant start my server (urgent please)

[ram]

Hi

i cant start the server.....,its giving following error in
nt event viewer,any help please
we are running on sqlserver 6.5

Error : 1105, Severity: 17, State: 2
Can't allocate space for object 'Syslogs' in database 'master' 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.

thanks in advance
bye
ram

[Bob]

I would try bringing the server up in minimal configuration mode (see sqlservr Command-line Executable in BOL) then dump the log for master with nolog, dump master, increase the size of master, dump master again. Then shutdown sql server and bring it back up.

Good luck.


------------
ram at 8/22/00 3:34:21 PM


Hi

i cant start the server.....,its giving following error in
nt event viewer,any help please
we are running on sqlserver 6.5

Error : 1105, Severity: 17, State: 2
Can't allocate space for object 'Syslogs' in database 'master' 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.

thanks in advance
bye
ram