解决SQL Server 2005 启动失败抛异常3174的问题

启动时弹出：“请求失败或服务未及时响应。有关具体信息，请参见事件日志或其它相关错误日志。”

查看日志内容如下：

2007-06-08 22:37:13.62 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 2)

2007-06-08 22:37:13.62 Server (c) 2005 Microsoft Corporation.
2007-06-08 22:37:13.62 Server All rights reserved.
2007-06-08 22:37:13.62 Server Server process ID is 3092.
2007-06-08 22:37:13.62 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG '.
2007-06-08 22:37:13.62 Server This instance of SQL Server last reported using a process ID of 2836 at 2007-6-8 22:30:33 (local) 2007-6-8 14:30:33 (UTC). This is an informational message only; no user action is required.

2007-06-08 22:37:13.62 Server Registry startup parameters:
2007-06-08 22:37:13.62 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-06-08 22:37:13.62 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-06-08 22:37:13.62 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-06-08 22:37:13.65 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-06-08 22:37:13.65 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-06-08 22:37:13.99 Server 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.

2007-06-08 22:37:14.10 Server Database Mirroring Transport is disabled in the endpoint configuration.
2007-06-08 22:37:14.13 spid5s Starting up database 'master '.
2007-06-08 22:37:14.15 spid5s Error: 5118, Severity: 16, State: 1.
2007-06-08 22:37:14.15 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.
2007-06-08 22:37:14.15 spid5s Error: 5118, Severity: 16, State: 1.
2007-06-08 22:37:14.15 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.


2007-06-08 22:37:14.16 spid5s Error: 5118, Severity: 16, State: 1.
2007-06-08 22:37:14.16 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.
2007-06-08 22:37:14.16 spid5s Error: 5118, Severity: 16, State: 1.
2007-06-08 22:37:14.16 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.


不知为什么会发生这样的事情？因为前段时间还启动得起，又没有人为的修改刚才的设置(怀疑是硬盘整理时,系统会自动将其属性设置为compressed,以便节省空间)。

其实该问题解决非常简单，只需完成下面的步骤:
1右键点击C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA，
2点击属性，在常规选项卡中点击高级，
3在弹出的窗口中的压缩或加密属性中去掉压缩内容或者节省磁盘空间，点击确定
4点击应用，勾选应用于该文件夹所有文件 即可
或者只需对数据库系统必须的几个数据库:master,model,msdb,tempdb等做2、3操作即可

[本日志由 techmango 于 2010-04-19 11:09 PM 编辑]
文章来自: 本站原创
引用通告: 查看所有引用 | 我要引用此文章
Tags: SQL Server 2005SQL Server 2005 异常异常 decompresseddecompressed