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!
View Complete Post