標題: 解決MSSQL6.5設定TempDB in RAM過大導致SQL Server無法啟動問題 [打印本頁] 作者: bestlong 時間: 2007-6-5 08:34 標題: 解決MSSQL6.5設定TempDB in RAM過大導致SQL Server無法啟動問題
因為 MSSQL 6.5 Server 出現 TempDB 空間不足的訊息,所以通知所有用戶離線並進行系統調教增加空間,然後重新啟動服務就出現下列錯誤訊息:
kernel udactivate(IN_RAM): Operating system error 8(Not enough storage is available to process this command.) encountered
spid1 Device activation error. The physical filename 'IN_RAM' may be incorrect
spid1 crdb_tempdb: Unable to move tempdb into RAM; RAM device doesn't exist, cannot be created, or doesn't have enough space for tempdb