数据库必须重新服务器后才能连接上

霜知坚冰 霜知坚冰 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
每隔1个礼拜我的服务器必须重启,不然连接不上数据库。数据库报错
08/19/2019 08:17:28,spid5s,未知,SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
08/19/2019 08:17:28,spid5s,未知,.NET Framework runtime has been stopped.
08/19/2019 08:17:28,spid21s,未知,The current event was not reported to the Windows Events log. Operating system error = (null). You may need to clear the Windows Events log if it is full.
08/19/2019 08:17:28,spid21s,未知,Error: 17054<c/> Severity: 16<c/> State: 1.
08/19/2019 08:17:28,spid21s,未知,Service Broker manager has shut down.
08/19/2019 08:17:27,服务器,未知,SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
08/19/2019 02:00:14,备份,未知,Database backed up. Database: PathologyXP<c/> creation date(time): 2019/04/26(08:45:31)<c/> pages dumped: 6685<c/> first LSN: 775:6686:37<c/> last LSN: 775:6703:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\PACSDB\PathologyXP_backup_2019_08_19_020001_4982676.bak'}). This is an informational message only. No user action is required.
08/19/2019 02:00:14,备份,未知,Database backed up. Database: PACSDB<c/> creation date(time): 2019/04/23(20:16:08)<c/> pages dumped: 617004<c/> first LSN: 223203:3203:251<c/> last LSN: 223203:3308:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\PACSDB\PACSDB_backup_2019_08_19_020001_4932667.bak'}). This is an informational message only. No user action is required.
08/19/2019 02:00:05,备份,未知,Database backed up. Database: PACS<c/> creation date(time): 2019/04/23(20:16:00)<c/> pages dumped: 256432<c/> first LSN: 18716:25769:205<c/> last LSN: 18716:25855:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\PACSDB\PACS_backup_2019_08_19_020001_4862662.bak'}). This is an informational message only. No user action is required.
08/19/2019 00:00:05,spid20s,未知,This instance of SQL Server has been using a process ID of 1608 since 2019/8/13 9:51:24 (local) 2019/8/13 1:51:24 (UTC). This is an informational message only; no user action is required.
08/18/2019 02:00:38,备份,未知,Database backed up. Database: PathologyXP<c/> creation date(time): 2019/04/26(08:45:31)<c/> pages dumped: 6685<c/> first LSN: 775:6662:37<c/> last LSN: 775:6679:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\PACSDB\PathologyXP_backup_2019_08_18_020001_3498939.bak'}). This is an informational message only. No user action is required.
08/18/2019 02:00:37,备份,未知,Database backed up. Database: PACSDB<c/> creation date(time): 2019/04/23(20:16:08)<c/> pages dumped: 616748<c/> first LSN: 223198:3745:258<c/> last LSN: 223198:3853:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\PACSDB\PACSDB_backup_2019_08_18_020001_3458918.bak'}). This is an informational message only. No user action is required.
08/18/2019 02:00:13,备份,未知,Database backed up. Database: PACS<c/> creation date(time): 2019/04/23(20:16:00)<c/> pages dumped: 256048<c/> first LSN: 18716:692:239<c/> last LSN: 18716:792:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\PACSDB\PACS_backup_2019_08_18_020001_3378916.bak'}). This is an informational message only. No user action is required.
08/18/2019 00:00:42,spid30s,未知,This instance of SQL Server has been using a process ID of 1608 since 2019/8/13 9:51:24 (local) 2019/8/13 1:51:24 (UTC). This is an informational message only; no user action is required.
08/17/2019 15:50:39,登录,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“pacs1”。 [客户端: 10.1.7.14]
08/17/2019 15:50:39,登录,未知,错误: 18456,严重性: 14,状态: 38。
08/17/2019 02:00:19,备份,未知,Database backed up. Database: Pathology


重新启动数据库服务没有用,必须得重新启动服务器
...全文

相关推荐

IDEA:连接本地MySQL能用,连接Linux内MySQL报错[08001]无法创建与数据库服务器的连接。尝试重新连接3次。

前言: 使用IntelliJ IDEA连接本机MySQL没有问题,在连接Linux内MySQL时。报错:无法创建与数据库服务器的连接。尝试重新连接3次。放弃!!  问题原因: 经过长时间的百度查询与查阅IDEA官方提供的报错解决方案,终于找到了原因(还是自己太菜,没有经历过!!) 原因就是MySQL驱动版本的问题。本地MySQL驱动使用的是8.0版本的驱动,而Linux内的MySQL版本是5.1版本,驱动版本太高所以导致连接不成功,把驱动改成相对应的版本即可。      解决问题: IDEA内置可以下载对应的5.1版本的驱动  位置:  此方法已解决本博主的问题,如果您未解决请下方留言!!!

weixin_38715772

Oracle Database Lite 技术白皮书.pdf

Oracle Database Lite 技术白皮书.pdf

lzbu

PIC_SEG_DB:此代码可以与MS Access数据库连接并重新驱动信息

#READ ME ##此代码可以连接,以使用ODBC软件包与MS ACCESS数据库连接。 \ n ##稍后我们可以进行分类。

钟离舟

c#连接sqlserver数据库的代码和方式.docx

。

apple_51426592

SqlServer强制断开数据库已有连接的方法

在执行建库脚本时,往往会先将原有的数据库drop掉,由于SqlServer检测到有数据连接时禁止执行drop database操作,所以建库脚本经常执行失败,为此我们需要一种能强制断开数据库已有连接的方法,可以过如下t-sql实现: 代码如下: declare @i int declare cur cursor for select spid from sysprocesses where db_name(dbid)= ‘Your_Database_Name’ open cur fetch next from cur into @i while @@fetch_status=0 begin

weixin_38502290
评论 2
收藏 已收藏
分享
返回顶部
霜知坚冰
疑难问题 22,298 成员 121,727 内容