資料庫故障
MS SQL 6.5 資料庫又爆炸了,有一些資料莫名奇妙的亂掉,檢查日誌只有看到下列錯誤訊息。
2006/11/02 14:55:09.49 spid138 Error : 1105, Severity: 17, State: 1
2006/11/02 14:55:09.49 spid138 Can’t allocate space for object ‘-4417’ in database ‘tempdb’ because the ‘system’ 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.
2006/11/02 14:55:09.51 spid138 Error : 1510, Severity: 20, State: 2
2006/11/02 14:55:09.51 spid138 Sort failed: Out of space or locks in database ‘tempdb’2006/11/02 15:36:33.51 spid120 Error : 1105, Severity: 17, State: 1
2006/11/02 15:36:33.51 spid120 Can’t allocate space for object ‘-3841’ in database ‘tempdb’ because the ‘system’ 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.
2006/11/02 15:36:33.52 spid120 Error : 1510, Severity: 20, State: 2
2006/11/02 15:36:33.52 spid120 Sort failed: Out of space or locks in database ‘tempdb’
Leave a Reply