win 2016服务器std集群sql server 2017附加2012数据库问题 [英] win 2016 server std cluster sql server 2017 Attaching 2012 database issue

问题描述

win 2016服务器std集群sql server 2017生产

active-active sql cluster

win 2016 server std cluster sql server 2017 production
active-active sql cluster

所有最近应用的补丁。

SSMS 2017最新版本。

all recent patches applied.
SSMS 2017 latest version.

将2012数据库附加到SQL服务器实例2017花了很长时间，错误日志显示不一致错误。


在进程被终止后，用户无法连接到SQL服务器实例。
$


SQl Server实例发生了什么？为什么用户无法连接到实例？



问候，

谢尔盖·b $ b $

Attaching 2012 database to SQL server instance 2017 took long time and error log showed inconsistency errors.
After the process was killed users were unable to connect to the SQL server instance.

What happened to SQl Server instance? why users were unable to connect to the instance?

Regards,
Sergei

谢尔盖

推荐答案

进一步说明：



附加大型2012年2.4 TB数据库。

SQL Server RAM 980 GB 。

用户的问题在启动附加大型数据库的过程后立即发生。

即使在进程被杀死后，用户也无法连接。



重启SQL Server实例后问题得到解决。



Sergei

Further clarification:

Attaching large sq 2012 database of 2.4 TBs.
SQL Server RAM 980 GBs.
The issue with users happened immediately after the process of attaching a large database was started.
Even after the process was killed the users were unable to connect.

The issue was resolved after restarting SQL server instance.

Sergei

这篇关于win 2016服务器std集群sql server 2017附加2012数据库问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！