Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

in logshipping showing time_Since_last_backup is -60 mintures Expand / Collapse
Author
Message
Posted Tuesday, July 8, 2014 10:27 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:45 AM
Points: 101, Visits: 358
hi,

any one can help me

I ran the below sp on primary server

sp_help_log_shipping_monitor

time_Since_last_backup is -60 mintures

my log backup and restores are working fine without any problem why it is showing - value..Please help on this..
Post #1590430
Posted Tuesday, July 8, 2014 11:07 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:45 AM
Points: 101, Visits: 358
i found that my server time has been changed to prior to actual time.. i have reset it now the problem is clear
Post #1590441
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse