Link to home
Start Free TrialLog in
Avatar of Orwellian23
Orwellian23

asked on

SQL 2012 Log Shipping - log_shipping_monitor_primary table Not Updating

I'm in the processes of setting up and testing Log Shipping between (2) SQL 2012 servers.  Server A is the primary DB and Server B is the secondary DB and Monitor Server.  I've run through the setup process, letting SQL perform the initial backup and restore to create the secondary database.  Everything seems to be working fine.  The backup job kicks off every 15 mins on Server A and the corresponding files are created.  Copy/Restore jobs on Server B picking the new backups and restore them successfully.

Here comes the problem, when I run a Transaction Log Shipping Status report the "Time since Last Backup" is never getting updated and results in a Alert after the 60 min threshold is breached.  I doubled check the tabled log_shipping_monitor_primary and the last backup appears to correspond to the initial backup performed when log shipping was configured.  SQL and Agent services are running with a domain user account, same account on both systems.  I'm attempting to use profiler to follow the process but have not been able to find a silver bullet.  

Any help is much appreciated and if you need additional details fire away.
Avatar of Mark Ely
Mark Ely
Flag of United States of America image

Are both recovery model set to "Full"?

 Also run
sp_refresh_log_shipping_monitor
Avatar of Orwellian23
Orwellian23

ASKER

Yes
ASKER CERTIFIED SOLUTION
Avatar of Orwellian23
Orwellian23

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Issues resolved itself, no input affected outcome.