在msdb.dbo.log_shipping_monitor_primary中，Last_Backup_File为Null [英] Last_Backup_File is Null in msdb.dbo.log_shipping_monitor_primary

问题描述

您好，

我有SQL Server 2005 x64 SP2 Ent的日志传送设置。埃德。数据库使用监视服务器。我自己在辅助服务器上恢复了数据库，并在设置日志传送之前将其与主服务器同步。我没有任何日志传送问题，tx日志已备份，复制到辅助服务并恢复。

但是，log_shipping_monitor_primary表中的last_backup_file，last_backup_date和last_backup_date_utc列都是Null。我检查了log_shipping_monitor_secondary表，它显示了last_copied_ *和last_restored_ *列的正确和更新信息。

我尝试在@ primary_type = 0的情况下运行sp_refresh_log_shipping_monitor，使用@mode作为1& 2但它没有任何帮助。我删除了日志传送并从头开始重新设置，但同样的问题仍然存在。

我有8个其他数据库使用该监控服务器，但他们没有这个问题。唯一的区别是其他数据库都在32位标准版上。

有没有人知道如何解决这个问题？基本上，我需要last_Backup_file来将日志ftp到我们的备份中心。

谢谢！

解决方案

这个数据库和其他数据库的另一个区别是，它位于集群环境中，而其他数据库都是独立的数据库服务器。结果

Hi There,

I have log shipping setup for a SQL Server 2005 x64 SP2 Ent. Ed. database using a monitor server. I restored the database on the secondary server myself and synched it with primary before setting up log shipping. I don't have any issues with Log shipping, the tx log is backed up, copied over to the secondary and restored.

However, last_backup_file, last_backup_date and last_backup_date_utc columns in log_shipping_monitor_primary table are all Null. I checked the log_shipping_monitor_secondary table and it shows the correct and updated information for last_copied_* and last_restored_* columns.

I tried running sp_refresh_log_shipping_monitor with @agent_type=0 on primary with @mode as both 1 & 2 but it did not help in any way. I deleted the log shipping and set it up again from scratch but the same issue remains.

I have 8 other databases using that monitor server but they do not have this issue. The only difference being that the rest of databases are on 32 bit Std Edition.

Does anyone has any idea on how to resolve this? Basically, I need the last_Backup_file to ftp the logs to our backup center.

Thanks!

解决方案

Another difference between this database and other databases is that this is on a clustered environment, while other databases are all stand-alone database servers.

这篇关于在msdb.dbo.log_shipping_monitor_primary中，Last_Backup_File为Null的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！