SQL Server Configuration Manager-->SQL Server Services-->SQL Server (MSSQLSERVER) -->右键-->属性-->高级-->Dump Directory-->打开Dump Directory参数的目录.. -->按时间[修改日期]排序-->找到最新的ERRORLOG文件-->用记事本打开-->有详细无法启动错误信息..根据错误信息针对性的解决,若有问题请把详细错误信息贴上来..
强人 不过 我没太明白 应该怎么处理 信息如下 =====================和之前已贴出来过的一样的信息================================= 2013-08-10 11:46:49.12 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (Intel X86) Apr 22 2011 11:57:00 Copyright (c) Microsoft Corporation Enterprise Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)2013-08-10 11:46:49.12 Server (c) Microsoft Corporation. 2013-08-10 11:46:49.12 Server All rights reserved. 2013-08-10 11:46:49.12 Server Server process ID is 5500. 2013-08-10 11:46:49.12 Server Authentication mode is MIXED. 2013-08-10 11:46:49.12 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'. 2013-08-10 11:46:49.12 Server This instance of SQL Server last reported using a process ID of 4860 at 2013-8-10 11:36:33 (local) 2013-8-10 3:36:33 (UTC). This is an informational message only; no user action is required. 2013-08-10 11:46:49.12 Server Registry startup parameters: -d C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf -e C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG -l C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf 2013-08-10 11:46:49.12 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required. 2013-08-10 11:46:49.12 服务器 Detected 2 CPUs. This is an informational message; no user action is required. 2013-08-10 11:46:49.15 服务器 SQL Server is not configured to use all of the available system memory. To enable SQL Server to use more memory, set the awe enabled option to 1 by using the sp_configure stored procedure. 2013-08-10 11:46:49.21 服务器 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-08-10 11:46:49.27 服务器 Node configuration: node 0: CPU mask: 0x00000003:0 Active CPU mask: 0x00000003: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-08-10 11:46:49.28 spid7s Starting up database 'master'. ==========================以下开始不一样的============================= 2013-08-10 11:46:49.29 spid7s 错误: 5118,严重性: 16,状态: 1。 2013-08-10 11:46:49.29 spid7s 文件 "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf" 已压缩,但未驻留在只读数据库或文件组中。必须将此文件解压缩。 2013-08-10 11:46:49.29 spid7s 错误: 5118,严重性: 16,状态: 1。 2013-08-10 11:46:49.29 spid7s 文件 "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf" 已压缩,但未驻留在只读数据库或文件组中。必须将此文件解压缩。 ======================================================================
SQL SERVER(SQL EXPRESS)
SQL SERVER(MSSQLSERVER)
有两个,估计你是安装失败后某些服务无法启动,你去找原因还不如弄个干净的系统重新安装
-->右键-->属性-->高级-->Dump Directory-->打开Dump Directory参数的目录..
-->按时间[修改日期]排序-->找到最新的ERRORLOG文件-->用记事本打开-->有详细无法启动错误信息..根据错误信息针对性的解决,若有问题请把详细错误信息贴上来..
不过 我没太明白 应该怎么处理
信息如下
=====================和之前已贴出来过的一样的信息=================================
2013-08-10 11:46:49.12 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (Intel X86)
Apr 22 2011 11:57:00
Copyright (c) Microsoft Corporation
Enterprise Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)2013-08-10 11:46:49.12 Server (c) Microsoft Corporation.
2013-08-10 11:46:49.12 Server All rights reserved.
2013-08-10 11:46:49.12 Server Server process ID is 5500.
2013-08-10 11:46:49.12 Server Authentication mode is MIXED.
2013-08-10 11:46:49.12 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2013-08-10 11:46:49.12 Server This instance of SQL Server last reported using a process ID of 4860 at 2013-8-10 11:36:33 (local) 2013-8-10 3:36:33 (UTC). This is an informational message only; no user action is required.
2013-08-10 11:46:49.12 Server Registry startup parameters:
-d C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2013-08-10 11:46:49.12 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2013-08-10 11:46:49.12 服务器 Detected 2 CPUs. This is an informational message; no user action is required.
2013-08-10 11:46:49.15 服务器 SQL Server is not configured to use all of the available system memory. To enable SQL Server to use more memory, set the awe enabled option to 1 by using the sp_configure stored procedure.
2013-08-10 11:46:49.21 服务器 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-08-10 11:46:49.27 服务器 Node configuration: node 0: CPU mask: 0x00000003:0 Active CPU mask: 0x00000003: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-08-10 11:46:49.28 spid7s Starting up database 'master'.
==========================以下开始不一样的=============================
2013-08-10 11:46:49.29 spid7s 错误: 5118,严重性: 16,状态: 1。
2013-08-10 11:46:49.29 spid7s 文件 "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf" 已压缩,但未驻留在只读数据库或文件组中。必须将此文件解压缩。
2013-08-10 11:46:49.29 spid7s 错误: 5118,严重性: 16,状态: 1。
2013-08-10 11:46:49.29 spid7s 文件 "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf" 已压缩,但未驻留在只读数据库或文件组中。必须将此文件解压缩。
======================================================================
我把错误提示的文件解压缩,才解决问题的,也不知道哪个软件把这些数据库压缩起来的
根据以下错误信息
“C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf" 已压缩,但未驻留在只读数据库或文件组中。必须将此文件解压缩”