当前位置:数据库 > SQLServer >>

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数据库,它们之间会有影响不?

CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,