sql server(mssql server )无法启动
错误详情如下 Log日记
2009-12-28 12:49:05.24 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)
2009-12-28 12:49:05.26 Server (c) 2005 Microsoft Corporation.
2009-12-28 12:49:05.26 Server All rights reserved.
2009-12-28 12:49:05.26 Server Server process ID is 2752.
2009-12-28 12:49:05.26 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2009-12-28 12:49:05.28 Server This instance of SQL Server last reported using a process ID of 1440 at 2009-10-28 12:15:01 (local) 2009-10-28 4:15:01 (UTC). This is an informational message only; no user action is required.
2009-12-28 12:49:05.29 Server Registry startup parameters:
2009-12-28 12:49:05.32 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2009-12-28 12:49:05.32 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2009-12-28 12:49:05.32 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2009-12-28 12:49:05.40 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2009-12-28 12:49:05.42 服务器 Detected 1 CPUs. This is an informational message; no user action is required.
2009-12-28 12:49:06.46 服务器 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.
2009-12-28 12:49:07.92 服务器 Database Mirroring Transport is disabled in the endpoint configuration.
2009-12-28 12:49:08.26 spid5s Starting up database 'master'.
2009-12-28 12:49:08.40 spid5s 错误: 5118,严重性: 16,状态: 1。
2009-12-28 12:49:08.40 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.
2009-12-28 12:49:08.46 spid5s 错误: 5118,严重性: 16,状态: 1。
2009-12-28 12:49:08.46 spid5s 文件 "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" 已压缩,但未驻留在只读数据库或文件组中。必须将此文件解压缩。
2009-12-28 12:49:08.53 spid5s 错误: 5118,严重性: 16,状态: 1。
2009-12-28 12:49:08.53 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.
2009-12-28 12:49:08.53 spid5s 错误: 5118,严重性: 16,状态: 1。
2009-12-28 12:49:08.53 spid5s 文件 "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf" 已压缩,但未驻留在只读数据库或文件组中。必须将此文件解压缩。
答案:从日志情况看,应该是你把C盘的属性中选中了“压缩文件以节约磁盘空间”选项,导致Master数据库被压缩了。
其他:C盘是ntfs的?
那么去掉压缩文件以节约磁盘空间这钩。就好了。
你把系统数据库master.mdb设置成只读和压缩属性了。 可能出现了文件丢失 一个试试~ ~
上一个:在MSSQL SERVER 2000上的语言在MSSQL SERVER 2005上可以实现,它们是不是没有什么差别啊?
下一个:我在windows2003系统上同时装上了mssql server2000和mssql server 2005数据库,它们之间会有影响不?