说MASTER数据库要修复 ，但服务没启动进去如何修改呀？
14 个解决方案
#2
先看下~~
另外，你可以看下这边
SQL Server Configuration Manager-->SQL Server Services-->SQL Server (MSSQLSERVER)
-->右键-->属性-->高级-->Dump Directory-->打开Dump Directory参数的目录..
-->按时间[修改日期]排序-->找到最新的ERRORLOG文件-->用记事本打开-->
有详细无法启动错误信息..
另外，你可以看下这边
SQL Server Configuration Manager-->SQL Server Services-->SQL Server (MSSQLSERVER)
-->右键-->属性-->高级-->Dump Directory-->打开Dump Directory参数的目录..
-->按时间[修改日期]排序-->找到最新的ERRORLOG文件-->用记事本打开-->
有详细无法启动错误信息..
#3
ERRORLOG日志如下，请指点：
2015-02-10 14:06:12.96 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
2015-02-10 14:06:12.96 Server (c) 2005 Microsoft Corporation.
2015-02-10 14:06:12.96 Server All rights reserved.
2015-02-10 14:06:12.96 Server Server process ID is 4888.
2015-02-10 14:06:12.96 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG'.
2015-02-10 14:06:12.96 Server This instance of SQL Server last reported using a process ID of 2700 at 2015-2-10 14:05:38 (local) 2015-2-10 6:05:38 (UTC). This is an informational message only; no user action is required.
2015-02-10 14:06:12.96 Server Registry startup parameters:
2015-02-10 14:06:12.96 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf
2015-02-10 14:06:12.96 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG
2015-02-10 14:06:12.96 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\mastlog.ldf
2015-02-10 14:06:12.98 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2015-02-10 14:06:12.98 服务器 Detected 2 CPUs. This is an informational message; no user action is required.
2015-02-10 14:06:13.04 服务器 Set AWE Enabled to 1 in the configuration parameters to allow use of more memory.
2015-02-10 14:06:13.29 服务器 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.
2015-02-10 14:06:13.48 服务器 Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2015-02-10 14:06:14.50 服务器 Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2015-02-10 14:06:14.53 服务器 Database Mirroring Transport is disabled in the endpoint configuration.
2015-02-10 14:06:14.67 spid5s Starting up database 'master'.
2015-02-10 14:06:14.76 spid5s 2 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2015-02-10 14:06:14.82 spid5s 1 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2015-02-10 14:06:14.82 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2015-02-10 14:06:14.96 spid5s SQL Trace ID 1 was started by login "sa".
2015-02-10 14:06:15.00 spid5s Starting up database 'mssqlsystemresource'.
2015-02-10 14:06:15.15 spid5s Server name is 'SHANGHAI-D82ADB'. This is an informational message only. No user action is required.
2015-02-10 14:06:15.15 spid9s Starting up database 'model'.
2015-02-10 14:06:15.21 spid9s Clearing tempdb database.
2015-02-10 14:06:15.34 服务器 A self-generated certificate was successfully loaded for encryption.
2015-02-10 14:06:15.34 服务器 Server is listening on [ 'any' <ipv4> 1433].
2015-02-10 14:06:15.34 服务器 Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2015-02-10 14:06:15.34 服务器 Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2015-02-10 14:06:15.34 服务器 Server is listening on [ 127.0.0.1 <ipv4> 1434].
2015-02-10 14:06:15.34 服务器 Dedicated admin connection support was established for listening locally on port 1434.
2015-02-10 14:06:19.51 服务器 The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2015-02-10 14:06:19.51 服务器 SQL Server is now ready for client connections. This is an informational message; no user action is required.
2015-02-10 14:06:27.75 spid12s Starting up database 'msdb'.
2015-02-10 14:06:27.75 spid13s Starting up database 'AIS20110627114130'.
2015-02-10 14:06:27.75 spid14s Starting up database 'AIS20110627114212'.
2015-02-10 14:06:32.64 spid13s 1 transactions rolled forward in database 'AIS20110627114130' (5). This is an informational message only. No user action is required.
2015-02-10 14:06:32.64 spid12s 1 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
2015-02-10 14:06:32.81 spid5s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
2015-02-10 14:06:32.81 spid5s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2015-02-10 14:06:32.90 spid5s 0 transactions rolled back in database 'AIS20110627114130' (5). This is an informational message only. No user action is required.
2015-02-10 14:06:32.90 spid5s Recovery is writing a checkpoint in database 'AIS20110627114130' (5). This is an informational message only. No user action is required.
2015-02-10 14:06:39.07 spid9s 错误: 823，严重性: 24，状态: 2。
2015-02-10 14:06:39.07 spid9s The operating system returned error 23(数据错误(循环冗余检查)。) to SQL Server during a 读取 at offset 0x00000000342000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
2015-02-10 14:06:39.46 spid9s Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive and then restart SQL Server. Check for additional errors in the event log that may indicate why the tempdb files could not be initialized.
2015-02-10 14:06:39.46 spid5s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
2015-02-10 14:06:39.46 spid9s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
2015-02-10 14:06:39.67 服务器 The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Administrator should deregister this SPN manually to avoid client authentication errors.
2015-02-10 14:06:12.96 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
2015-02-10 14:06:12.96 Server (c) 2005 Microsoft Corporation.
2015-02-10 14:06:12.96 Server All rights reserved.
2015-02-10 14:06:12.96 Server Server process ID is 4888.
2015-02-10 14:06:12.96 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG'.
2015-02-10 14:06:12.96 Server This instance of SQL Server last reported using a process ID of 2700 at 2015-2-10 14:05:38 (local) 2015-2-10 6:05:38 (UTC). This is an informational message only; no user action is required.
2015-02-10 14:06:12.96 Server Registry startup parameters:
2015-02-10 14:06:12.96 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf
2015-02-10 14:06:12.96 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG
2015-02-10 14:06:12.96 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\mastlog.ldf
2015-02-10 14:06:12.98 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2015-02-10 14:06:12.98 服务器 Detected 2 CPUs. This is an informational message; no user action is required.
2015-02-10 14:06:13.04 服务器 Set AWE Enabled to 1 in the configuration parameters to allow use of more memory.
2015-02-10 14:06:13.29 服务器 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.
2015-02-10 14:06:13.48 服务器 Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2015-02-10 14:06:14.50 服务器 Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2015-02-10 14:06:14.53 服务器 Database Mirroring Transport is disabled in the endpoint configuration.
2015-02-10 14:06:14.67 spid5s Starting up database 'master'.
2015-02-10 14:06:14.76 spid5s 2 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2015-02-10 14:06:14.82 spid5s 1 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2015-02-10 14:06:14.82 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2015-02-10 14:06:14.96 spid5s SQL Trace ID 1 was started by login "sa".
2015-02-10 14:06:15.00 spid5s Starting up database 'mssqlsystemresource'.
2015-02-10 14:06:15.15 spid5s Server name is 'SHANGHAI-D82ADB'. This is an informational message only. No user action is required.
2015-02-10 14:06:15.15 spid9s Starting up database 'model'.
2015-02-10 14:06:15.21 spid9s Clearing tempdb database.
2015-02-10 14:06:15.34 服务器 A self-generated certificate was successfully loaded for encryption.
2015-02-10 14:06:15.34 服务器 Server is listening on [ 'any' <ipv4> 1433].
2015-02-10 14:06:15.34 服务器 Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2015-02-10 14:06:15.34 服务器 Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2015-02-10 14:06:15.34 服务器 Server is listening on [ 127.0.0.1 <ipv4> 1434].
2015-02-10 14:06:15.34 服务器 Dedicated admin connection support was established for listening locally on port 1434.
2015-02-10 14:06:19.51 服务器 The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2015-02-10 14:06:19.51 服务器 SQL Server is now ready for client connections. This is an informational message; no user action is required.
2015-02-10 14:06:27.75 spid12s Starting up database 'msdb'.
2015-02-10 14:06:27.75 spid13s Starting up database 'AIS20110627114130'.
2015-02-10 14:06:27.75 spid14s Starting up database 'AIS20110627114212'.
2015-02-10 14:06:32.64 spid13s 1 transactions rolled forward in database 'AIS20110627114130' (5). This is an informational message only. No user action is required.
2015-02-10 14:06:32.64 spid12s 1 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
2015-02-10 14:06:32.81 spid5s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
2015-02-10 14:06:32.81 spid5s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2015-02-10 14:06:32.90 spid5s 0 transactions rolled back in database 'AIS20110627114130' (5). This is an informational message only. No user action is required.
2015-02-10 14:06:32.90 spid5s Recovery is writing a checkpoint in database 'AIS20110627114130' (5). This is an informational message only. No user action is required.
2015-02-10 14:06:39.07 spid9s 错误: 823，严重性: 24，状态: 2。
2015-02-10 14:06:39.07 spid9s The operating system returned error 23(数据错误(循环冗余检查)。) to SQL Server during a 读取 at offset 0x00000000342000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
2015-02-10 14:06:39.46 spid9s Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive and then restart SQL Server. Check for additional errors in the event log that may indicate why the tempdb files could not be initialized.
2015-02-10 14:06:39.46 spid5s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
2015-02-10 14:06:39.46 spid9s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
2015-02-10 14:06:39.67 服务器 The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Administrator should deregister this SPN manually to avoid client authentication errors.
#4
日志上看是MASTER的问题，需要用你发的重建是吗？
#5
如果你不能进去的话应该要重建了，
#6
非常感谢 版主，通过你给的重建完可以进去了，就是原来的数据库重新附加下，数据是不会丢失的吧？非常感谢
#7
除了MASTER报了一人严重的错误，信息还提示临时数据库无法创建，空间不足
Could not create tempdb. You may not have enough disk space available
你先按大版的方法先重建一下MASTER试下
Could not create tempdb. You may not have enough disk space available
你先按大版的方法先重建一下MASTER试下
#8
master 库存放服务器层面的信息，还有服务器层面的账号等，如果重建会导致这些信息丢失，对于用户数据库的信息，一般影响不大。
#9
谢谢两位高手。
但空间还有很大剩余，不知道为什么会提示空间不足？
但空间还有很大剩余，不知道为什么会提示空间不足？
#10
看看tempdb所在的盘
#11
虽然有这个错误信息，可能是MASTER的原因引起的，日志信息也是这么描述的。建议先尝试修复。
#12
所以盘都有好几十G的剩余空间
#13
Tempdb初始化不会很夸张吧
#14
先把数据文件备份出来，MASTER坏掉，也可能其他数据文件（块）也有可能，或者磁盘不稳定
若仅仅是MASTER坏掉，重装下SQL SERVER（若有备份MASTER，就单用户模式SQL CMD恢复）
或者把其他相同版本号的MASTER文件复制过来
若仅仅是MASTER坏掉，重装下SQL SERVER（若有备份MASTER，就单用户模式SQL CMD恢复）
或者把其他相同版本号的MASTER文件复制过来
#1
#2
先看下~~
另外，你可以看下这边
SQL Server Configuration Manager-->SQL Server Services-->SQL Server (MSSQLSERVER)
-->右键-->属性-->高级-->Dump Directory-->打开Dump Directory参数的目录..
-->按时间[修改日期]排序-->找到最新的ERRORLOG文件-->用记事本打开-->
有详细无法启动错误信息..
另外，你可以看下这边
SQL Server Configuration Manager-->SQL Server Services-->SQL Server (MSSQLSERVER)
-->右键-->属性-->高级-->Dump Directory-->打开Dump Directory参数的目录..
-->按时间[修改日期]排序-->找到最新的ERRORLOG文件-->用记事本打开-->
有详细无法启动错误信息..
#3
ERRORLOG日志如下，请指点：
2015-02-10 14:06:12.96 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
2015-02-10 14:06:12.96 Server (c) 2005 Microsoft Corporation.
2015-02-10 14:06:12.96 Server All rights reserved.
2015-02-10 14:06:12.96 Server Server process ID is 4888.
2015-02-10 14:06:12.96 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG'.
2015-02-10 14:06:12.96 Server This instance of SQL Server last reported using a process ID of 2700 at 2015-2-10 14:05:38 (local) 2015-2-10 6:05:38 (UTC). This is an informational message only; no user action is required.
2015-02-10 14:06:12.96 Server Registry startup parameters:
2015-02-10 14:06:12.96 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf
2015-02-10 14:06:12.96 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG
2015-02-10 14:06:12.96 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\mastlog.ldf
2015-02-10 14:06:12.98 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2015-02-10 14:06:12.98 服务器 Detected 2 CPUs. This is an informational message; no user action is required.
2015-02-10 14:06:13.04 服务器 Set AWE Enabled to 1 in the configuration parameters to allow use of more memory.
2015-02-10 14:06:13.29 服务器 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.
2015-02-10 14:06:13.48 服务器 Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2015-02-10 14:06:14.50 服务器 Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2015-02-10 14:06:14.53 服务器 Database Mirroring Transport is disabled in the endpoint configuration.
2015-02-10 14:06:14.67 spid5s Starting up database 'master'.
2015-02-10 14:06:14.76 spid5s 2 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2015-02-10 14:06:14.82 spid5s 1 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2015-02-10 14:06:14.82 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2015-02-10 14:06:14.96 spid5s SQL Trace ID 1 was started by login "sa".
2015-02-10 14:06:15.00 spid5s Starting up database 'mssqlsystemresource'.
2015-02-10 14:06:15.15 spid5s Server name is 'SHANGHAI-D82ADB'. This is an informational message only. No user action is required.
2015-02-10 14:06:15.15 spid9s Starting up database 'model'.
2015-02-10 14:06:15.21 spid9s Clearing tempdb database.
2015-02-10 14:06:15.34 服务器 A self-generated certificate was successfully loaded for encryption.
2015-02-10 14:06:15.34 服务器 Server is listening on [ 'any' <ipv4> 1433].
2015-02-10 14:06:15.34 服务器 Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2015-02-10 14:06:15.34 服务器 Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2015-02-10 14:06:15.34 服务器 Server is listening on [ 127.0.0.1 <ipv4> 1434].
2015-02-10 14:06:15.34 服务器 Dedicated admin connection support was established for listening locally on port 1434.
2015-02-10 14:06:19.51 服务器 The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2015-02-10 14:06:19.51 服务器 SQL Server is now ready for client connections. This is an informational message; no user action is required.
2015-02-10 14:06:27.75 spid12s Starting up database 'msdb'.
2015-02-10 14:06:27.75 spid13s Starting up database 'AIS20110627114130'.
2015-02-10 14:06:27.75 spid14s Starting up database 'AIS20110627114212'.
2015-02-10 14:06:32.64 spid13s 1 transactions rolled forward in database 'AIS20110627114130' (5). This is an informational message only. No user action is required.
2015-02-10 14:06:32.64 spid12s 1 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
2015-02-10 14:06:32.81 spid5s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
2015-02-10 14:06:32.81 spid5s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2015-02-10 14:06:32.90 spid5s 0 transactions rolled back in database 'AIS20110627114130' (5). This is an informational message only. No user action is required.
2015-02-10 14:06:32.90 spid5s Recovery is writing a checkpoint in database 'AIS20110627114130' (5). This is an informational message only. No user action is required.
2015-02-10 14:06:39.07 spid9s 错误: 823，严重性: 24，状态: 2。
2015-02-10 14:06:39.07 spid9s The operating system returned error 23(数据错误(循环冗余检查)。) to SQL Server during a 读取 at offset 0x00000000342000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
2015-02-10 14:06:39.46 spid9s Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive and then restart SQL Server. Check for additional errors in the event log that may indicate why the tempdb files could not be initialized.
2015-02-10 14:06:39.46 spid5s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
2015-02-10 14:06:39.46 spid9s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
2015-02-10 14:06:39.67 服务器 The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Administrator should deregister this SPN manually to avoid client authentication errors.
2015-02-10 14:06:12.96 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
2015-02-10 14:06:12.96 Server (c) 2005 Microsoft Corporation.
2015-02-10 14:06:12.96 Server All rights reserved.
2015-02-10 14:06:12.96 Server Server process ID is 4888.
2015-02-10 14:06:12.96 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG'.
2015-02-10 14:06:12.96 Server This instance of SQL Server last reported using a process ID of 2700 at 2015-2-10 14:05:38 (local) 2015-2-10 6:05:38 (UTC). This is an informational message only; no user action is required.
2015-02-10 14:06:12.96 Server Registry startup parameters:
2015-02-10 14:06:12.96 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf
2015-02-10 14:06:12.96 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG
2015-02-10 14:06:12.96 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\mastlog.ldf
2015-02-10 14:06:12.98 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2015-02-10 14:06:12.98 服务器 Detected 2 CPUs. This is an informational message; no user action is required.
2015-02-10 14:06:13.04 服务器 Set AWE Enabled to 1 in the configuration parameters to allow use of more memory.
2015-02-10 14:06:13.29 服务器 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.
2015-02-10 14:06:13.48 服务器 Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2015-02-10 14:06:14.50 服务器 Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2015-02-10 14:06:14.53 服务器 Database Mirroring Transport is disabled in the endpoint configuration.
2015-02-10 14:06:14.67 spid5s Starting up database 'master'.
2015-02-10 14:06:14.76 spid5s 2 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2015-02-10 14:06:14.82 spid5s 1 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2015-02-10 14:06:14.82 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2015-02-10 14:06:14.96 spid5s SQL Trace ID 1 was started by login "sa".
2015-02-10 14:06:15.00 spid5s Starting up database 'mssqlsystemresource'.
2015-02-10 14:06:15.15 spid5s Server name is 'SHANGHAI-D82ADB'. This is an informational message only. No user action is required.
2015-02-10 14:06:15.15 spid9s Starting up database 'model'.
2015-02-10 14:06:15.21 spid9s Clearing tempdb database.
2015-02-10 14:06:15.34 服务器 A self-generated certificate was successfully loaded for encryption.
2015-02-10 14:06:15.34 服务器 Server is listening on [ 'any' <ipv4> 1433].
2015-02-10 14:06:15.34 服务器 Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2015-02-10 14:06:15.34 服务器 Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2015-02-10 14:06:15.34 服务器 Server is listening on [ 127.0.0.1 <ipv4> 1434].
2015-02-10 14:06:15.34 服务器 Dedicated admin connection support was established for listening locally on port 1434.
2015-02-10 14:06:19.51 服务器 The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2015-02-10 14:06:19.51 服务器 SQL Server is now ready for client connections. This is an informational message; no user action is required.
2015-02-10 14:06:27.75 spid12s Starting up database 'msdb'.
2015-02-10 14:06:27.75 spid13s Starting up database 'AIS20110627114130'.
2015-02-10 14:06:27.75 spid14s Starting up database 'AIS20110627114212'.
2015-02-10 14:06:32.64 spid13s 1 transactions rolled forward in database 'AIS20110627114130' (5). This is an informational message only. No user action is required.
2015-02-10 14:06:32.64 spid12s 1 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
2015-02-10 14:06:32.81 spid5s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
2015-02-10 14:06:32.81 spid5s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2015-02-10 14:06:32.90 spid5s 0 transactions rolled back in database 'AIS20110627114130' (5). This is an informational message only. No user action is required.
2015-02-10 14:06:32.90 spid5s Recovery is writing a checkpoint in database 'AIS20110627114130' (5). This is an informational message only. No user action is required.
2015-02-10 14:06:39.07 spid9s 错误: 823，严重性: 24，状态: 2。
2015-02-10 14:06:39.07 spid9s The operating system returned error 23(数据错误(循环冗余检查)。) to SQL Server during a 读取 at offset 0x00000000342000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
2015-02-10 14:06:39.46 spid9s Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive and then restart SQL Server. Check for additional errors in the event log that may indicate why the tempdb files could not be initialized.
2015-02-10 14:06:39.46 spid5s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
2015-02-10 14:06:39.46 spid9s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
2015-02-10 14:06:39.67 服务器 The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Administrator should deregister this SPN manually to avoid client authentication errors.
#4
日志上看是MASTER的问题，需要用你发的重建是吗？
#5
如果你不能进去的话应该要重建了，
#6
非常感谢 版主，通过你给的重建完可以进去了，就是原来的数据库重新附加下，数据是不会丢失的吧？非常感谢
#7
除了MASTER报了一人严重的错误，信息还提示临时数据库无法创建，空间不足
Could not create tempdb. You may not have enough disk space available
你先按大版的方法先重建一下MASTER试下
Could not create tempdb. You may not have enough disk space available
你先按大版的方法先重建一下MASTER试下
#8
master 库存放服务器层面的信息，还有服务器层面的账号等，如果重建会导致这些信息丢失，对于用户数据库的信息，一般影响不大。
#9
谢谢两位高手。
但空间还有很大剩余，不知道为什么会提示空间不足？
但空间还有很大剩余，不知道为什么会提示空间不足？
#10
看看tempdb所在的盘
#11
虽然有这个错误信息，可能是MASTER的原因引起的，日志信息也是这么描述的。建议先尝试修复。
#12
所以盘都有好几十G的剩余空间
#13
Tempdb初始化不会很夸张吧
#14
先把数据文件备份出来，MASTER坏掉，也可能其他数据文件（块）也有可能，或者磁盘不稳定
若仅仅是MASTER坏掉，重装下SQL SERVER（若有备份MASTER，就单用户模式SQL CMD恢复）
或者把其他相同版本号的MASTER文件复制过来
若仅仅是MASTER坏掉，重装下SQL SERVER（若有备份MASTER，就单用户模式SQL CMD恢复）
或者把其他相同版本号的MASTER文件复制过来