none
sql 2012 servervices 不能启动,错误代码1067, RRS feed

  • 问题

  • Mssql 2012  server 不能启动,错误代码1067,

    以下是查看2012server 事件查看器中的内容 

    initerrlog: 无法打开错误日志文件 'F:\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG'。操作系统错误 = 3(系统找不到指定的路径。)。

    联系电话:180-2695-8761

    以下是SQL error log

    2018-08-07 13:09:45.77 Server      Microsoft SQL Server 2012 - 11.0.5058.0 (X64)
     May 14 2014 18:34:29
     Copyright (c) Microsoft Corporation
     Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 9600: )

    2018-08-07 13:09:45.77 Server      (c) Microsoft Corporation.
    2018-08-07 13:09:45.77 Server      All rights reserved.
    2018-08-07 13:09:45.77 Server      Server process ID is 6428.
    2018-08-07 13:09:45.78 Server      System Manufacturer: 'Dell Inc.', System Model: 'PowerEdge R730'.
    2018-08-07 13:09:45.78 Server      Authentication mode is MIXED.
    2018-08-07 13:09:45.78 Server      Logging SQL Server messages in file 'F:\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
    2018-08-07 13:09:45.78 Server      The service account is 'YUEMUSQL2\Administrator'. This is an informational message; no user action is required.
    2018-08-07 13:09:45.79 Server      Registry startup parameters:
      -d F:\MSSQL11.MSSQLSERVER\MSSQL\DATA\master.mdf
      -e F:\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG
      -l F:\MSSQL11.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
    2018-08-07 13:09:45.79 Server      Command Line Startup Parameters:
      -s "MSSQLSERVER"
    2018-08-07 13:09:46.16 Server      SQL Server detected 2 sockets with 14 cores per socket and 28 logical processors per socket, 56 total logical processors; using 56 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
    2018-08-07 13:09:46.16 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2018-08-07 13:09:46.16 Server      Detected 130978 MB of RAM. This is an informational message; no user action is required.
    2018-08-07 13:09:46.16 Server      Using conventional memory in the memory manager.
    2018-08-07 13:09:47.51 Server      This instance of SQL Server last reported using a process ID of 5232 at 2018/8/7 12:53:00 (local) 2018/8/7 4:53:00 (UTC). This is an informational message only; no user action is required.
    2018-08-07 13:09:47.51 Server      Node configuration: node 0: CPU mask: 0x000000000fffffff:0 Active CPU mask: 0x000000000fffffff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2018-08-07 13:09:47.51 Server      Node configuration: node 1: CPU mask: 0x00fffffff0000000:0 Active CPU mask: 0x00fffffff0000000:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2018-08-07 13:09:47.62 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.
    2018-08-07 13:09:47.62 Server      Lock partitioning is enabled.  This is an informational message only. No user action is required.
    2018-08-07 13:09:47.64 Server      Software Usage Metrics is disabled.
    2018-08-07 13:09:47.65 spid5s      Starting up database 'master'.
    2018-08-07 13:09:47.72 spid5s      627 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.
    2018-08-07 13:09:47.75 spid5s      0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.
    2018-08-07 13:09:47.75 spid5s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
    2018-08-07 13:09:47.91 Server      CLR version v4.0.30319 loaded.
    2018-08-07 13:09:47.93 spid5s      Resource governor reconfiguration succeeded.
    2018-08-07 13:09:47.93 spid5s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.
    2018-08-07 13:09:47.94 spid5s      SQL Server Audit has started the audits. This is an informational message. No user action is required.
    2018-08-07 13:09:48.03 spid5s      SQL Trace ID 1 was started by login "sa".
    2018-08-07 13:09:48.06 spid5s      Server name is 'SQL2012'. This is an informational message only. No user action is required.
    2018-08-07 13:09:48.06 spid5s      The NETBIOS name of the local node that is running the server is 'YUEMUSQL2'. This is an informational message only. No user action is required.
    2018-08-07 13:09:48.11 Server      Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
    2018-08-07 13:09:48.12 spid15s     A self-generated certificate was successfully loaded for encryption.
    2018-08-07 13:09:48.20 spid15s     Server is listening on [ 192.168.9.246 <ipv4> 1433].
    2018-08-07 13:09:48.20 spid15s     Started listening on virtual network name 'SQL2012'. No user action is required.
    2018-08-07 13:09:48.21 spid15s     Server local connection provider is ready to accept connection on
    2018-08-07 13:09:48.21 spid15s     Server named pipe provider is ready to accept connection on
    2018-08-07 13:09:48.21 spid15s     SQL Server is now ready for client connections. This is an informational message; no user action is required.
    2018-08-07 13:09:48.21 Server      SQL Server is attempting to register a Service Principal Name (SPN) for the SQL Server service. Kerberos authentication will not be possible until a SPN is registered for the SQL Server service. This is an informational message. No user action is required.
    2018-08-07 13:09:48.21 Server      The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/SQL2012.ym.cn ] for the SQL Server service. Windows return code: 0xffffffff, state: 53. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.
    2018-08-07 13:09:48.21 Server      The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/SQL2012.ym.cn:1433 ] for the SQL Server service. Windows return code: 0xffffffff, state: 53. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.
    2018-08-07 13:09:48.54 Logon       错误: 18456,严重性: 14,状态: 38。
    2018-08-07 13:09:48.54 Logon       Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“yuemu”。 [客户端: 192.168.9.242]
    2018-08-07 13:09:48.54 Logon       错误: 18456,严重性: 14,状态: 38。
    2018-08-07 13:09:48.54 Logon       Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“yuemu”。 [客户端: 192.168.9.242]
    2018-08-07 13:09:48.54 Logon       错误: 18456,严重性: 14,状态: 38。
    2018-08-07 13:09:48.54 Logon       Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“yuemu”。 [客户端: 192.168.9.242]
    2018-08-07 13:09:48.54 Logon       错误: 18456,严重性: 14,状态: 38。
    2018-08-07 13:09:48.54 Logon       Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“yuemu”。 [客户端: 192.168.9.242]
    2018-08-07 13:09:48.54 Logon       错误: 18456,严重性: 14,状态: 38。
    2018-08-07 13:09:48.54 Logon       Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“yuemu”。 [客户端: 192.168.9.242]
    2018-08-07 13:09:48.56 spid17s     A new instance of the full-text filter daemon host process has been successfully started.
    2018-08-07 13:09:48.62 spid22s     Starting up database 'yuemu'.
    2018-08-07 13:09:48.62 spid19s     Starting up database 'ReportServer'.
    2018-08-07 13:09:48.62 spid23s     Starting up database 'ReportServerTempDB'.
    2018-08-07 13:09:48.62 spid21s     Starting up database 'V3SPDoc'.
    2018-08-07 13:09:48.62 spid20s     Starting up database 'msdb'.
    2018-08-07 13:09:48.63 spid11s     Starting up database 'mssqlsystemresource'.
    2018-08-07 13:09:48.64 spid11s     The resource database build version is 11.00.5058. This is an informational message only. No user action is required.
    2018-08-07 13:09:48.74 spid11s     Starting up database 'model'.
    2018-08-07 13:09:48.74 spid23s     34 transactions rolled forward in database 'ReportServerTempDB' (8:0). This is an informational message only. No user action is required.
    2018-08-07 13:09:48.76 spid20s     155 transactions rolled forward in database 'msdb' (4:0). This is an informational message only. No user action is required.
    2018-08-07 13:09:48.78 spid11s     Clearing tempdb database.
    2018-08-07 13:09:48.84 spid5s      0 transactions rolled back in database 'ReportServerTempDB' (8:0). This is an informational message only. No user action is required.
    2018-08-07 13:09:48.84 spid5s      Recovery is writing a checkpoint in database 'ReportServerTempDB' (8). This is an informational message only. No user action is required.
    2018-08-07 13:09:48.86 spid11s     Starting up database 'tempdb'.
    2018-08-07 13:09:48.93 spid24s     The Service Broker endpoint is in disabled or stopped state.
    2018-08-07 13:09:48.93 spid24s     The Database Mirroring endpoint is in disabled or stopped state.
    2018-08-07 13:09:48.94 spid20s     0 transactions rolled back in database 'msdb' (4:0). This is an informational message only. No user action is required.
    2018-08-07 13:09:48.94 spid20s     Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
    2018-08-07 13:09:48.94 spid24s     Service Broker manager has started.
    2018-08-07 13:09:49.53 spid19s     14 transactions rolled forward in database 'ReportServer' (5:0). This is an informational message only. No user action is required.
    2018-08-07 13:09:49.78 spid5s      0 transactions rolled back in database 'ReportServer' (5:0). This is an informational message only. No user action is required.
    2018-08-07 13:09:49.78 spid5s      Recovery is writing a checkpoint in database 'ReportServer' (5). This is an informational message only. No user action is required.
    2018-08-07 13:09:49.93 spid53      Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
    2018-08-07 13:09:49.95 spid53      Using 'xpsqlbot.dll' version '2011.110.2100' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
    2018-08-07 13:09:50.06 spid53      Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
    2018-08-07 13:09:50.07 spid53      Using 'xpstar.dll' version '2011.110.5058' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
    2018-08-07 13:09:50.10 spid53      Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
    2018-08-07 13:09:50.11 spid53      Using 'xplog70.dll' version '2011.110.5058' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
    2018-08-07 13:09:52.11 spid21s     1 transactions rolled forward in database 'V3SPDoc' (6:0). This is an informational message only. No user action is required.
    2018-08-07 13:09:52.18 spid21s     0 transactions rolled back in database 'V3SPDoc' (6:0). This is an informational message only. No user action is required.
    2018-08-07 13:10:00.59 Logon       错误: 18456,严重性: 14,状态: 38。
    2018-08-07 13:10:00.59 Logon       Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“yuemu”。 [客户端: 192.168.9.242]
    2018-08-07 13:10:00.59 Logon       错误: 18456,严重性: 14,状态: 38。
    2018-08-07 13:10:00.59 Logon       Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“yuemu”。 [客户端: 192.168.9.242]
    2018-08-07 13:10:00.59 Logon       错误: 18456,严重性: 14,状态: 38。
    2018-08-07 13:10:00.59 Logon       Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“yuemu”。 [客户端: 192.168.9.242]
    2018-08-07 13:10:00.59 Logon       错误: 18456,严重性: 14,状态: 38。
    2018-08-07 13:10:00.59 Logon       Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“yuemu”。 [客户端: 192.168.9.242]
    2018-08-07 13:10:00.59 Logon       错误: 18456,严重性: 14,状态: 38。
    2018-08-07 13:10:00.59 Logon       Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“yuemu”。 [客户端: 192.168.9.242]
    2018-08-07 13:10:12.01 spid22s     Database yuemu has more than 1000 virtual log files which is excessive. Too many virtual log files can cause long startup and backup times. Consider shrinking the log and using a different growth increment to reduce the number of virtual log files.
    2018-08-07 13:10:12.10 spid22s     110 transactions rolled forward in database 'yuemu' (7:0). This is an informational message only. No user action is required.
    2018-08-07 13:10:12.37 spid5s      0 transactions rolled back in database 'yuemu' (7:0). This is an informational message only. No user action is required.
    2018-08-07 13:10:12.37 spid5s      Recovery is writing a checkpoint in database 'yuemu' (7). This is an informational message only. No user action is required.
    2018-08-07 13:10:12.44 spid5s      Recovery is complete. This is an informational message only. No user action is required.
    2018-08-07 13:10:12.45 spid5s      Launched startup procedure 'P_StartUp'.
    2018-08-07 13:10:12.45 spid33s     DBCC TRACEON 1224, server process ID (SPID) 33. This is an informational message only; no user action is required.
    2018-08-07 13:10:12.45 spid33s     DBCC 执行完毕。如果 DBCC 输出了错误信息,请与系统管理员联系。
    2018-08-07 13:10:12.45 spid33s     DBCC TRACEON 2371, server process ID (SPID) 33. This is an informational message only; no user action is required.
    2018-08-07 13:10:12.45 spid33s     DBCC 执行完毕。如果 DBCC 输出了错误信息,请与系统管理员联系。
    2018-08-07 13:10:12.49 spid33s     配置选项 'clr enabled' 已从 1 更改为 1。请运行 RECONFIGURE 语句进行安装。
    2018-08-07 13:10:12.49 spid33s     Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.
    2018-08-07 13:27:30.26 spid58      AppDomain 2 (yuemu.dbo[runtime].1) created.
    2018-08-07 13:27:30.37 spid58      Unsafe assembly 'ufida.u9.sql.clrlib, version=0.0.0.0, culture=neutral, publickeytoken=null, processorarchitecture=msil' loaded into appdomain 2 (yuemu.dbo[runtime].1).
    2018-08-07 13:27:30.40 spid58      Unsafe assembly 'ufida.u9.sql.clrlib, version=0.0.0.0, culture=neutral, publickeytoken=null, processorarchitecture=msil' loaded into appdomain 2 (yuemu.dbo[runtime].1).
    2018-08-07 14:08:08.38 spid67      AppDomain 3 (yuemu.dbo[runtime].2) created.
    2018-08-07 14:08:08.38 spid67      Unsafe assembly 'ufida.u9.sql.clrlib, version=0.0.0.0, culture=neutral, publickeytoken=null, processorarchitecture=msil' loaded into appdomain 3 (yuemu.dbo[runtime].2).
    2018-08-07 14:08:08.39 spid67      Unsafe assembly 'ufida.u9.sql.clrlib, version=0.0.0.0, culture=neutral, publickeytoken=null, processorarchitecture=msil' loaded into appdomain 3 (yuemu.dbo[runtime].2).

    2018年8月7日 8:02

全部回复