你这个是神马情况,感觉看不出错误啊
错误就是我现在在数据库上执行任何操作都会错,都报错!像这样:
@菜鸟NET行: 真的没遇到过这样的,那你试下楼下的打补丁更新下看看,精简版的好像是会有一些bug的
光看图信息不全,来个错误日志也行,重启看看。
重启了很多次了,错误日志我给您找来了,您看看:
2013-05-08 22:07:27.74 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86)
Apr 2 2010 15:53:02
Copyright (c) Microsoft Corporation
Enterprise Evaluation Edition on Windows NT 6.2 <X86> (Build 9200: )
2013-05-08 22:07:27.77 Server (c) Microsoft Corporation.
2013-05-08 22:07:27.77 Server All rights reserved.
2013-05-08 22:07:27.77 Server Server process ID is 1616.
2013-05-08 22:07:27.77 Server System Manufacturer: 'Hewlett-Packard', System Model: 'Presario CQ42 Notebook PC'.
2013-05-08 22:07:27.78 Server Authentication mode is MIXED.
2013-05-08 22:07:27.78 Server Logging SQL Server messages in file 'F:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2013-05-08 22:07:27.79 Server This instance of SQL Server last reported using a process ID of 1516 at 2013/5/8 22:06:17 (local) 2013/5/8 14:06:17 (UTC). This is an informational message only; no user action is required.
2013-05-08 22:07:27.79 Server Registry startup parameters:
-d F:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf
-e F:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l F:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2013-05-08 22:07:27.85 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2013-05-08 22:07:27.85 服务器 Detected 4 CPUs. This is an informational message; no user action is required.
2013-05-08 22:07:28.28 服务器 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-05-08 22:07:29.83 服务器 Node configuration: node 0: CPU mask: 0x0000000f:0 Active CPU mask: 0x0000000f: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-05-08 22:07:30.26 spid6s Starting up database 'master'.
2013-05-08 22:07:30.46 spid6s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2013-05-08 22:07:30.73 spid6s Resource governor reconfiguration succeeded.
2013-05-08 22:07:30.73 spid6s SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2013-05-08 22:07:30.76 spid6s SQL Server Audit has started the audits. This is an informational message. No user action is required.
2013-05-08 22:07:30.77 spid6s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-05-08 22:07:30.97 spid6s SQL Trace ID 1 was started by login "sa".
2013-05-08 22:07:30.98 spid6s Starting up database 'mssqlsystemresource'.
2013-05-08 22:07:31.00 spid6s The resource database build version is 10.50.1600. This is an informational message only. No user action is required.
2013-05-08 22:07:31.20 spid11s Starting up database 'model'.
2013-05-08 22:07:31.23 spid6s Server name is 'DOTNET'. This is an informational message only. No user action is required.
2013-05-08 22:07:31.37 spid11s Clearing tempdb database.
2013-05-08 22:07:31.77 spid11s Starting up database 'tempdb'.
2013-05-08 22:07:31.92 spid13s The Service Broker protocol transport is disabled or not configured.
2013-05-08 22:07:31.92 spid13s The Database Mirroring protocol transport is disabled or not configured.
2013-05-08 22:07:31.97 spid13s Service Broker manager has started.
2013-05-08 22:07:32.31 服务器 A self-generated certificate was successfully loaded for encryption.
2013-05-08 22:07:32.34 服务器 Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2013-05-08 22:07:32.34 服务器 Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2013-05-08 22:07:32.35 服务器 Server is listening on [ ::1 <ipv6> 1434].
2013-05-08 22:07:32.36 服务器 Server is listening on [ 127.0.0.1 <ipv4> 1434].
2013-05-08 22:07:32.36 服务器 Dedicated admin connection support was established for listening locally on port 1434.
2013-05-08 22:07:32.37 服务器 The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. 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.
2013-05-08 22:07:32.37 服务器 SQL Server is now ready for client connections. This is an informational message; no user action is required.
2013-05-08 22:07:34.88 spid20s A new instance of the full-text filter daemon host process has been successfully started.
2013-05-08 22:07:35.13 spid20s Starting up database 'msdb'.
2013-05-08 22:07:35.13 spid24s Starting up database 'ProficientDB'.
2013-05-08 22:07:35.13 spid21s Starting up database 'ReportServer'.
2013-05-08 22:07:35.13 spid23s Starting up database 'exam'.
2013-05-08 22:07:35.13 spid25s Starting up database 'socialSecurity'.
2013-05-08 22:07:35.13 spid22s Starting up database 'ReportServerTempDB'.
2013-05-08 22:07:36.29 spid6s Recovery is complete. This is an informational message only. No user action is required.
2013-05-09 08:47:38.92 spid21s This instance of SQL Server has been using a process ID of 1616 since 2013/5/8 22:07:36 (local) 2013/5/8 14:07:36 (UTC). This is an informational message only; no user action is required.
一种情况是没有更新SP,SQL Express本身的BUG。如果都是最新的SP,那可能就是你的脚本有错误了,最傻瓜的办法就是执行一段看下效果,直到全部执行看看那段出错了。
有可能是因为没有更新SP,现在正在试 SQL Server 2008 Express 看看会不会错。不过脚本是肯定没问题的,用过很多次,在不是Express下是没问题的。
数据库存储位置不对
这个应该不关事吧?我就随便存在硬盘的地方,是用脚本写的