Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

LSBackup shows no interest in running, does lsalert affect execution of LSBackup Expand / Collapse
Author
Message
Posted Wednesday, April 9, 2014 6:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 25, 2014 3:09 AM
Points: 3, Visits: 79
Hi

Have log shipping set up on Primary to offload *TRns every night.
At a point in time job failed because of power issues, and Db was shut down @ 17:00 hours, restarted next morning ( Log shipping did not happen over this two week period).

Now I get an LSalert notification that the lsalert job failed. however LSbackup does not attempt to start.

Executed as user: NT AUTHORITY\SYSTEM. The log shipping primary database GHADB05.PJX_P_MIG has backup threshold of 2880 minutes and has not performed a backup log operation for 141930 minutes. Check agent log and logshipping monitor information. [SQLSTATE 42000] (Error 14420). The step failed.

is this normal and how do I get restarted
Post #1559921
Posted Wednesday, April 9, 2014 7:49 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 25, 2014 2:56 AM
Points: 451, Visits: 1,665
What happens when you start it manually?
Post #1559950
Posted Wednesday, April 9, 2014 8:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 25, 2014 3:09 AM
Points: 3, Visits: 79
I have not tried this yet

what I have done is change the alert threshold so that the alert will not trigger.
waiting to see what happens tomorrow morning ( Job scheduled to run Midnight)

regards
Post #1559960
Posted Wednesday, April 9, 2014 2:48 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:18 AM
Points: 6,181, Visits: 13,328
is the schedule enabled?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1560186
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse