none
Windows 不能在 本地计算机 启动 SQL Server (MSSQLSERVER)。有关更多信息,查阅系统事件日志。如果这是非 Microsoft 服务,请与服务厂商联系,并参考特定服务错误代码 1814 RRS feed

  • 问题

  • 2013-10-21 16:12:59.52 Server      Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) 
    Apr  2 2010 15:48:46 
    Copyright (c) Microsoft Corporation
    Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)

    2013-10-21 16:12:59.59 Server      (c) Microsoft Corporation.
    2013-10-21 16:12:59.59 Server      All rights reserved.
    2013-10-21 16:12:59.59 Server      Server process ID is 3512.
    2013-10-21 16:12:59.59 Server      System Manufacturer: 'IBM', System Model: 'IBM System x3400 M3 Server -[7379I06]-'.
    2013-10-21 16:12:59.60 Server      Authentication mode is MIXED.
    2013-10-21 16:12:59.61 Server      Logging SQL Server messages in file 'D:\Program Files\SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
    2013-10-21 16:12:59.62 Server      This instance of SQL Server last reported using a process ID of 2836 at 2013/10/21 16:03:24 (local) 2013/10/21 8:03:24 (UTC). This is an informational message only; no user action is required.
    2013-10-21 16:12:59.62 Server      Registry startup parameters: 
    -d D:\Program Files\SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf
    -e D:\Program Files\SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG
    -l D:\Program Files\SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
    2013-10-21 16:12:59.62 Server      Command Line Startup Parameters:
    -m SqlSetup
    -T 4022
    -T 4010
    -T 1905
    2013-10-21 16:12:59.71 服务器         SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2013-10-21 16:12:59.71 服务器         Detected 8 CPUs. This is an informational message; no user action is required.
    2013-10-21 16:12:59.72 Server      Large Page Extensions enabled.
    2013-10-21 16:12:59.72 Server      Large Page Granularity: 2097152 
    2013-10-21 16:12:59.80 Server      Large Page Allocated: 32MB 
    2013-10-21 16:12:59.93 Server      Large Page Allocated: 32MB 
    2013-10-21 16:13:00.20 服务器         Using locked pages for buffer pool.
    2013-10-21 16:13:00.70 服务器         Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
    2013-10-21 16:13:00.99 服务器         Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
    2013-10-21 16:13:01.64 服务器         Node configuration: node 0: CPU mask: 0x00000000000000f0:0 Active CPU mask: 0x00000000000000f0:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2013-10-21 16:13:01.64 服务器         Node configuration: node 1: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2013-10-21 16:13:01.73 服务器         Database Mirroring Transport is disabled in the endpoint configuration.
    2013-10-21 16:13:01.74 spid9s      Warning ******************
    2013-10-21 16:13:01.77 spid9s      SQL Server started in single-user mode. This an informational message only. No user action is required.
    2013-10-21 16:13:01.85 spid9s      Starting up database 'master'.
    2013-10-21 16:13:03.66 spid9s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.
    2013-10-21 16:13:03.68 spid9s      SQL Server Audit has started the audits. This is an informational message. No user action is required.
    2013-10-21 16:13:03.71 spid9s      FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
    2013-10-21 16:13:04.10 spid9s      SQL Trace ID 1 was started by login "sa".
    2013-10-21 16:13:04.11 spid9s      Starting up database 'mssqlsystemresource'.
    2013-10-21 16:13:04.14 spid9s      The resource database build version is 10.50.1600. This is an informational message only. No user action is required.
    2013-10-21 16:13:04.35 spid9s      Server name is 'WIN-QBRE7SM0VRO'. This is an informational message only. No user action is required.
    2013-10-21 16:13:04.36 spid11s     Starting up database 'model'.
    2013-10-21 16:13:04.46 spid11s     The database 'model' is marked RESTORING and is in a state that does not allow recovery to be run.
    2013-10-21 16:13:04.50 spid11s     错误: 927,严重性: 14,状态: 2。
    2013-10-21 16:13:04.50 spid11s     无法打开数据库 'model'。该数据库正在进行还原。
    2013-10-21 16:13:04.60 spid11s     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 event log that may indicate why the tempdb files could not be initialized.
    2013-10-21 16:13:04.62 spid11s     SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

    http://www.sunth.tk |http:www.5dteam.net |www.crmim.com www.mscrm.tk 查mscrm技术资料请到www.crmim.com

    2013年10月21日 9:41

答案

  • 看到LZ给出的日志:

    主要问题有3个

    (1)

     错误: 927,严重性: 14,状态: 2。
    2013-10-21 16:13:04.50 spid11s     无法打开数据库 'model'。该数据库正在进行还原。
    (2)
    不能创建tempdb数据库,没有足够的磁盘空间
    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 event log that may indicate why the tempdb files could not be initialized.

    (3)

    SQLSERVER以单用户模式启动

    SQL Server started in single-user mode. This an informational message only. No user action is required.

    --------------------------------------------------------------------------------------

    如果LZ不是手动指定SQLSERVER启动模式,那么说明SQLSERVER有问题了

    不知道LZ有没有备份model数据库,如果有的话还原备份

    还有tempdb数据库所在磁盘的空间,LZ也要检查一下

    必要时可以重新生成model数据库

    重新生成系统数据库

    2013年10月21日 11:31

全部回复

  • 看到LZ给出的日志:

    主要问题有3个

    (1)

     错误: 927,严重性: 14,状态: 2。
    2013-10-21 16:13:04.50 spid11s     无法打开数据库 'model'。该数据库正在进行还原。
    (2)
    不能创建tempdb数据库,没有足够的磁盘空间
    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 event log that may indicate why the tempdb files could not be initialized.

    (3)

    SQLSERVER以单用户模式启动

    SQL Server started in single-user mode. This an informational message only. No user action is required.

    --------------------------------------------------------------------------------------

    如果LZ不是手动指定SQLSERVER启动模式,那么说明SQLSERVER有问题了

    不知道LZ有没有备份model数据库,如果有的话还原备份

    还有tempdb数据库所在磁盘的空间,LZ也要检查一下

    必要时可以重新生成model数据库

    重新生成系统数据库

    2013年10月21日 11:31
  • 谢谢楼上。

    http://www.sunth.tk |http:www.5dteam.net |www.crmim.com www.mscrm.tk 查mscrm技术资料请到www.crmim.com

    2013年10月21日 11:44
  • Because machine runs out disk space, clean them up then restart sql.
    2013年10月21日 13:42
  • system run out of space, clean some files then restart sql server. Becuase restore also need space to complete.


    Please Mark As Answer if it is helpful.

    2013年10月22日 3:13