大网数据广告活动
数据库与应用安全

Event ID 1814 is logged in the System log

· 52CE 我爱测

This article provides resolutions for the problem where SQL Server fails to start and Event ID 1814 is logged in the System log.

Applies to:   SQL Server

Symptoms

If the Microsoft SQL Server service can't create the Tempdb file during startup, the service doesn't start when you use Service Control Manager, and you receive the following error message:

Windows could not start the SQL Server (MSSQLSERVER) on Local Computer. For more information, review the System Event log.
If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 1814.

Cause

This problem can occur because of the following reasons:

  • The hard disk that was hosting Tempdb was removed or the drive letter changed for some reason.
  • There are space constraints at the OS layer.

Resolution

  1. Open the Application log, and verify that you see error message entries that resemble the following:

    Log Name:      Application  
    Source:        MSSQLSERVER  
    Date:          <Datetime>  
    Event ID:      5123  
    Task Category: Server  
    Level:         Error  
    Keywords:      Classic  
    User:          N/A  
    Computer:      <Server name>  
    Description:
    CREATE FILE encountered operating system error 3(The system cannot find the path specified.)
    while attempting to open or create the physical file <FilePath>.
    
    Log Name:      Application  
    Source:        MSSQLSERVER  
    Date:          <Datetime>  
    Event ID:      17204  
    Task Category: Server  
    Level:         Error  
    Keywords:      Classic  
    User:          N/A  
    Computer:      <Server name>  
    Description:
    FCB::Open failed: Could not open file <FilePath> for file number 1.  OS error: 3(The system cannot find the path specified.).
    
    Log Name:      Application  
    Source:        MSSQLSERVER  
    Date:          <Datetime>  
    Event ID:      1814  
    Task Category: Server  
    Level:         Information  
    Keywords:      Classic  
    User:          N/A
    Computer:      <Server name>  
    Description:
    Could not create tempdb. You may not have enough disk space available.
    Free additional disk space by deleting other files on the tempdb drive and then restart SQL Server.
    Check for additional errors in the operating system error log that may indicate why the tempdb files could not be initialized.
    
  2. To resolve the problem, move the Tempdb file to a different location by using the procedure that's mentioned in the Failure Recovery Procedure section of Move System Databases.

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors (upstream author metadata: aartig13). Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 01/28/2020
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。