none
modellog.ldf的讀取期間,傳回錯誤 38 RRS feed

  • 問題

  • 請教各位先進!

    目前客戶那邊的SQL Server Service無法啟動,看了一下log應該是下面的問題

    事件類型:    錯誤
    事件來源:    MSSQLSERVER
    事件類別目錄:    伺服器
    事件識別碼:    823
    日期:        2012/3/14
    時間:        下午 07:30:24
    使用者:        N/A
    電腦:    TBA01
    描述:
    作業系統在檔案 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\modellog.ldf' 中位移 0x00000001fb0000 的 讀取 期間,傳回錯誤 38(到達檔案結尾。) 給 SQL Server。SQL Server 錯誤記錄檔和系統事件記錄檔中的訊息或許可以提供其他詳細資訊。這是嚴重的系統層級錯誤狀況,且可能會損及資料庫的完整性,所以必須立即更正。請執行完整的資料庫一致性檢查 (DBCC CHECKDB)。導致這個錯誤的原因有許多可能性; 如需詳細資訊,請參閱《SQL Server 線上叢書》。

    請在 http://go.microsoft.com/fwlink/events.asp 查看說明及支援中心,以取得其他資訊。
    資料:
    0000: 37 03 00 00 18 00 00 00   7.......
    0008: 06 00 00 00 54 00 42 00   ....T.B.
    0010: 41 00 30 00 31 00 00 00   A.0.1...
    0018: 00 00 00 00               ....   

    請問這個問題應該如何解決呢?感恩...

    By Danny


    PS.目前已知的情況是,C磁碟有進行BESR的System Partition Backup,所以可以在之前的備份檔中,找到modellog.ldf和model.mdf,可以直接拿該二個檔案直接復原回去嗎?
    • 已編輯 DannyLee 2012年3月15日 上午 01:38
    2012年3月15日 上午 01:31

解答

所有回覆

  • 錯誤訊息 823 可能表示硬體問題或在 SQL Server 的系統問題


    ☞ 這裡是「免費的討論區」付費支援服務請造訪 此處享受尊榮服務
    如果回覆對您有幫助,請記得按下標示為解答」

    2012年3月15日 上午 01:42
    版主
  • 錯誤訊息 823 可能表示硬體問題或在 SQL Server 的系統問題


    ☞ 這裡是「免費的討論區」付費支援服務請造訪 此處享受尊榮服務
    如果回覆對您有幫助,請記得按下標示為解答」

    Alex 您好!

    剛剛已經有執行過chkdsk c:,但是沒有發現錯誤...

    接著執行 sqlservr.exe -m要嘗試進行Dbcc Checkdb('model', Repair_Rebuild),但是在執行 sqlservr.exe -m的時候就fail了

    C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn>sqlservr.ex
    e -m
    2012-03-15 09:52:51.70 Server      Microsoft SQL Server 2008 (SP1) - 10.0.2531.0
     (Intel X86)
            Mar 29 2009 10:27:29
            Copyright (c) 1988-2008 Microsoft Corporation
            Standard Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)

    2012-03-15 09:52:51.70 Server      (c) 2005 Microsoft Corporation.
    2012-03-15 09:52:51.70 Server      All rights reserved.
    2012-03-15 09:52:51.70 Server      Server process ID is 7756.
    2012-03-15 09:52:51.70 Server      Authentication mode is MIXED.
    2012-03-15 09:52:51.70 Server      Logging SQL Server messages in file 'C:\Progr
    am Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
    2012-03-15 09:52:51.70 Server      This instance of SQL Server last reported usi
    ng a process ID of 4848 at 2012/3/15 上午 09:21:13 (local) 2012/3/15 上午 01:21:
    13 (UTC). This is an informational message only; no user action is required.
    2012-03-15 09:52:51.70 Server      Registry startup parameters:
             -d C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA
    \master.mdf
             -e C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\
    ERRORLOG
             -l C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA
    \mastlog.ldf
    2012-03-15 09:52:51.71 Server      Command Line Startup Parameters:
             -m
    2012-03-15 09:52:51.71 伺服器         SQL Server is starting at normal priority
    base (=7). This is an informational message only. No user action is required.
    2012-03-15 09:52:51.73 伺服器         Detected 8 CPUs. This is an informational
    message; no user action is required.
    2012-03-15 09:52:51.96 伺服器         Perfmon counters for resource governor poo
    ls and groups failed to initialize and are disabled.
    2012-03-15 09:52:51.97 伺服器         Using dynamic lock allocation.  Initial al
    location of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an in
    formational message only.  No user action is required.
    2012-03-15 09:52:52.03 伺服器         Node configuration: node 0: CPU mask: 0x00
    0000ff Active CPU mask: 0x000000ff. This message provides a description of the N
    UMA configuration for this computer. This is an informational message only. No u
    ser action is required.
    2012-03-15 09:52:52.05 伺服器         Database Mirroring Transport is disabled i
    n the endpoint configuration.
    2012-03-15 09:52:52.06 spid6s      Warning ******************
    2012-03-15 09:52:52.06 spid6s      SQL Server started in single-user mode. This
    an informational message only. No user action is required.
    2012-03-15 09:52:52.06 spid6s      錯誤: 17120,嚴重性: 16,狀態: 1。
    2012-03-15 09:52:52.06 spid6s      SQL Server could not spawn CreateRecEvent() t
    hread. Check the SQL Server error log and the Windows event logs for information
     about possible related problems.
    2012-03-15 09:52:52.07 spid6s      Starting up database 'master'.
    2012-03-15 09:52:52.63 spid6s      FILESTREAM: effective level = 0, configured l
    evel = 0, file system access share name = 'MSSQLSERVER'.
    2012-03-15 09:52:52.71 spid6s      SQL Trace ID 1 was started by login "sa".
    2012-03-15 09:52:52.73 spid6s      Starting up database 'mssqlsystemresource'.
    2012-03-15 09:52:52.74 spid6s      The resource database build version is 10.00.
    2531. This is an informational message only. No user action is required.
    2012-03-15 09:52:52.93 spid6s      Server name is 'TBA01'. This is an informatio
    nal message only. No user action is required.
    2012-03-15 09:52:52.94 spid10s     Starting up database 'model'.
    2012-03-15 09:52:53.02 spid9s      錯誤: 9954,嚴重性: 16,狀態: 1。
    2012-03-15 09:52:53.02 spid9s      SQL Server failed to communicate with filter
    daemon launch service  (Windows error: 無法啟動服務,可能因為服務已停用,或它沒
    有相關的啟用裝置。
    ). Full-Text filter daemon process failed to start. Full-text search functionali
    ty will not be available.
    2012-03-15 09:52:53.03 spid13s     Starting up database 'distribution'.
    2012-03-15 09:52:53.03 spid9s      Starting up database 'msdb'.
    2012-03-15 09:52:53.03 spid12s     Starting up database 'tbadb'.
    2012-03-15 09:52:53.45 伺服器         A self-generated certificate was successfu
    lly loaded for encryption.
    2012-03-15 09:52:53.46 伺服器         Server is listening on [ 'any' <ipv4> 1433
    ].
    2012-03-15 09:52:53.47 伺服器         Server local connection provider is ready
    to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
    2012-03-15 09:52:53.47 伺服器         Server named pipe provider is ready to acc
    ept connection on [ \\.\pipe\sql\query ].
    2012-03-15 09:52:53.48 伺服器         Server is listening on [ 127.0.0.1 <ipv4>
    1434].
    2012-03-15 09:52:53.49 伺服器         Dedicated admin connection support was est
    ablished for listening locally on port 1434.
    2012-03-15 09:52:53.50 伺服器         The SQL Server Network Interface library c
    ould not register the Service Principal Name (SPN) for the SQL Server service. E
    rror: 0x54b, state: 3. Failure to register an SPN may cause integrated authentic
    ation to fall back to NTLM instead of Kerberos. This is an informational message
    . Further action is only required if Kerberos authentication is required by auth
    entication policies.
    2012-03-15 09:52:53.51 伺服器         SQL Server is now ready for client connect
    ions. This is an informational message; no user action is required.
    2012-03-15 09:52:53.73 spid9s      458 transactions rolled forward in database '
    msdb' (4). This is an informational message only. No user action is required.
    2012-03-15 09:52:53.79 spid10s     錯誤: 823,嚴重性: 24,狀態: 5。
    2012-03-15 09:52:53.79 spid10s     The operating system returned error 38(到達檔
    案結尾。) to SQL Server during a 讀取 at offset 0x00000001fb0000 in file 'C:\Pro
    gram Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\modellog.ldf'. Ad
    ditional messages in the SQL Server error log and system event log may provide m
    ore detail. This is a severe system-level error condition that threatens databas
    e integrity and must be corrected immediately. Complete a full database consiste
    ncy check (DBCC CHECKDB). This error can be caused by many factors; for more inf
    ormation, see SQL Server Books Online.
    2012-03-15 09:52:53.80 spid10s     錯誤: 17053,嚴重性: 16,狀態: 1。
    2012-03-15 09:52:53.80 spid10s     ReadFileHdr: Operating system error 38(到達檔
    案結尾。) encountered.
    2012-03-15 09:52:53.81 spid10s     錯誤: 5159,嚴重性: 24,狀態: 3。
    2012-03-15 09:52:53.81 spid10s     Operating system error 38(到達檔案結尾。) on
    file "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\model
    log.ldf" during ReadFileHdr.
    2012-03-15 09:52:53.82 spid10s     錯誤: 945,嚴重性: 14,狀態: 2。
    2012-03-15 09:52:53.82 spid10s     檔案無法存取、記憶體或磁碟空間不足,因此無法
    開啟資料庫 'model'。詳細資訊請參閱 SQL Server 錯誤記錄檔。
    2012-03-15 09:52:53.82 spid9s      0 transactions rolled back in database 'msdb'
     (4). This is an informational message only. No user action is required.
    2012-03-15 09:52:53.83 spid10s     Could not create tempdb. You may not have eno
    ugh 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
     event log that may indicate why the tempdb files could not be initialized.
    2012-03-15 09:52:53.83 spid9s      Recovery is writing a checkpoint in database
    'msdb' (4). This is an informational message only. No user action is required.
    2012-03-15 09:52:53.84 spid10s     SQL Trace was stopped due to server shutdown.
     Trace ID = '1'. This is an informational message only; no user action is requir
    ed.

    C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn>

    請問我們還有什麼方式可以處理?或是可以拿BESR備份檔中的modellog.ldf和model.mdf,拿該二個檔案直接覆蓋回去嗎?

    感謝!

    By Danny

    2012年3月15日 上午 01:59
  • Dear Alex

    目前我們已經拿3/11的BESR備份檔中之modellog.ldf和model.mdf,將該二個檔案直接覆蓋回去了,目前SQL Server服務已經可以正常啟動了...

    目前再持續觀察看看情況,有問題再跟各位請益,感恩 ^^


    2012年3月15日 上午 02:11