当前命令发生了严重错误。应放弃任何可能产生的结果

Question

sqlserver 2008 R2 EE CU7

执行一个存储过程对数据进行archive.但是,有些时候就会报错:
当前命令发生了严重错误。应放弃任何可能产生的结果。
我有对两边数据库进行DBCC CHECKDB,发现都没任何错误.
那我要怎么去解决呢?

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 1

Sql server log should have more details around that error message, double check log. Again, you should install latest sql service pack first when got those errors. Even MS support will ask you do so.

Answer 2

Sql server log should have more details around that error message, double check log. Again, you should install latest sql service pack first when got those errors. Even MS support will ask you do so.

我现在是cluster.如果打补丁的话,应该要怎么打呢?

还是先passive node之后转移再打之前的active node?

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 3

You can do that way, same as you install cu7.

Answer 4

你好，

SQL Server 2005之后的版本，对群集数据库实例打补丁，需要先从passive node上开始。对passive node 打完补丁后要重新启动，然后将数据库服务转移到已经打好补丁的passive node上，再对之前的active node打补丁。详细信息请参考这篇文章，同样适用于SQL Server 2008 R2版本：Apply a service pack or hotfix SQL Server 2008 to a failover cluster instance.

下面这个帖子也是关于这个问题的：Patching SQL 2008 R2 in Windows 2008 R2 cluster.

---

Stephanie Lv

TechNet Community Support

Answer 5

Depends on os version actually, above is true only on win2k8 and win2k8 r2.