none
sqlserver启动不了 RRS feed

  • 问题

  • 该服务未及时响应启动请求或控制请求。你需要拥有管理员特权,才能开始/停止该服务 错误

    log中显示

    2010-10-31 15:11:21.18 Server      Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
     Oct 14 2005 00:33:37
     Copyright (c) 1988-2005 Microsoft Corporation
     Express Edition on Windows NT 5.1 (Build 2600: Service Pack 3)

    2010-10-31 15:11:21.20 Server      (c) 2005 Microsoft Corporation.
    2010-10-31 15:11:21.20 Server      All rights reserved.
    2010-10-31 15:11:21.20 Server      Server process ID is 2616.
    2010-10-31 15:11:21.21 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
    2010-10-31 15:11:21.21 Server      This instance of SQL Server last reported using a process ID of 3792 at 2010-10-31 15:08:53 (local) 2010-10-31 7:08:53 (UTC). This is an informational message only; no user action is required.
    2010-10-31 15:11:21.23 Server      Registry startup parameters:
    2010-10-31 15:11:21.23 Server        -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
    2010-10-31 15:11:21.23 Server        -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
    2010-10-31 15:11:21.23 Server        -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
    2010-10-31 15:11:21.23 服务器         SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2010-10-31 15:11:21.24 服务器         Detected 2 CPUs. This is an informational message; no user action is required.
    2010-10-31 15:11:21.92 服务器         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.
    2010-10-31 15:11:21.98 服务器         Database Mirroring Transport is disabled in the endpoint configuration.
    2010-10-31 15:11:21.98 spid5s      Starting up database 'master'.
    2010-10-31 15:11:22.06 spid5s      错误: 5118,严重性: 16,状态: 1。
    2010-10-31 15:11:22.06 spid5s      The file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
    2010-10-31 15:11:22.07 spid5s      错误: 5118,严重性: 16,状态: 1。
    2010-10-31 15:11:22.07 spid5s      文件 "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" 已压缩,但未驻留在只读数据库或文件组中。必须将此文件解压缩。
    2010-10-31 15:11:22.07 spid5s      错误: 5118,严重性: 16,状态: 1。
    2010-10-31 15:11:22.07 spid5s      The file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
    2010-10-31 15:11:22.09 spid5s      错误: 5118,严重性: 16,状态: 1。
    2010-10-31 15:11:22.09 spid5s      文件 "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf" 已压缩,但未驻留在只读数据库或文件组中。必须将此文件解压缩。

    2010年10月31日 8:25

答案