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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-22 : 23:23:36
|
andy writes "Below are the error I got!
****************************************************************
The description for Event ID ( 17060 ) in Source ( MSSQLServer ) could not be found.
It contains the following insertion string(s):
Error : 1105, Severity: 17, State: 2,
Can't allocate space for object 'Syslogs' in database 'tempdb' 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..
*****************************************************************
I have tried to enchance the tempdb size daily but the server still down at 1:00Am due to the available size is empty everyday. I create a device to keep tempdb log but the tempdb data share with master. Any idea what is wrong ?
One of the solutions I can think of is to schedule the auto maintenance to truncate the tempdb size. Will it works ? If yes, how to schedule it. If not, what other way I can try?
Pls help and advise." |
|
|
|
|
|
Error : 1105, Severity: 17, State: 2 - SQL Server 6.5