ALTER DATABASE [DataBaseName] SET ONLINE时，5069 ALTER DATABASE语句失败 [英] 5069 ALTER DATABASE statements failed when ALTER DATABASE [DataBaseName] SET ONLINE

问题描述

在月底，我们为每个数据库提供了一个sql代理作业。它做的第一件事是将数据库脱机，然后立即重新联机。这些工作多年来一直在努力。现在在一个客户端的SQL服务器上，他的45个数据库中有25个
因"5069 ALTER DATABASE语句失败"而失败。运行语句"ALTER DATABASE [DataBaseName] SET ONLINE"时。今天早上，当我们重新启动失败的SQL代理作业时，它们都运行没有错误。 

At the end of the month we have a sql agent job for each database. The first thing it does is take the database off line and then immediately back online. These jobs have been working for years. Now at one client's sql server, maybe 25 of his 45 databases failed with "5069 ALTER DATABASE statement failed" when running the statement "ALTER DATABASE [DataBaseName] SET ONLINE". This morning when we reran the failed SQL Agent Jobs, they all ran without error. 

有关为什么这么多数据库在SET ONLINE上失败的任何想法？ 

Any ideas on why so many databases would fail on the SET ONLINE? 

推荐答案

您需要获得更好的诊断。我希望有一条附带的信息可以解释问题所在。但是，代理程序的作业历史记录并不能捕获完整的错误消息。设置输出文件有助于获得更好的诊断。
您可以在Step-creation对话框的Advanced选项卡上执行此操作。

You need to get better diagnostics. I would expect an accompanying message which explains what the problem is. Agent's job history is not that good of trapping the full error message though. Setting up an output file can help to get better diagnostics. You do that on the Advanced tab on the Step-creation dialog.

这篇关于ALTER DATABASE [DataBaseName] SET ONLINE时，5069 ALTER DATABASE语句失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！