I am trying to do log shipping but frequently getting error..i have created two folder in system one is source anoter one is destination in both folder log file generating but restoring job on secondary sever is failing from starting why it is like that can u tell me..?
error message in below
10/12/2015 17:50:00,LSRestore_C2SFA-PC_ator1,Error,0,C2SFA-PC\MEGH,LSRestore_C2SFA-PC_ator1,(Job outcome),,The job failed. The Job was invoked by Schedule 40 (DefaultRestoreJobSchedule). The last step to run was step 1 (Log shipping restore log job step.).,00:00:20,0,0,,,,0
10/12/2015 17:50:00,LSRestore_C2SFA-PC_ator1,Error,1,C2SFA-PC\MEGH,LSRestore_C2SFA-PC_ator1,Log shipping restore log job step.,,Executed as user: C2SFA-PC\SYSTEM. The step failed.,00:00:20,0,0,,,,0
10/12/2015 17:50:00,LSRestore_C2SFA-PC_ator1,In Progress,1,C2SFA-PC\MEGH,LSRestore_C2SFA-PC_ator1,Log shipping restore log job step.,,2015-10-12 17:50:20.82
10/12/2015 17:50:00,LSRestore_C2SFA-PC_ator1,In Progress,1,C2SFA-PC\MEGH,LSRestore_C2SFA-PC_ator1,Log shipping restore log job step.,,2015-10-12 17:50:20.65
10/12/2015 17:50:00,LSRestore_C2SFA-PC_ator1,In Progress,1,C2SFA-PC\MEGH,LSRestore_C2SFA-PC_ator1,Log shipping restore log job step.,,2015-10-12 17:50:00.61
10/12/2015 17:50:00,LSRestore_C2SFA-PC_ator1,In Progress,1,C2SFA-PC\MEGH,LSRestore_C2SFA-PC_ator1,Log shipping restore log job step.,,2015-10-12 17:50:00.55
10/12/2015 17:50:00,LSRestore_C2SFA-PC_ator1,In Progress,1,C2SFA-PC\MEGH,LSRestore_C2SFA-PC_ator1,Log shipping restore log job step.,,Microsoft (R) SQL Server Log Shipping Agent<nl>[Assembly Version = 10.0.0.0<c> File Version = 10.0.1600.22 ((SQL_PreRelease).080709-1414 )]<nl>Microsoft Corporation. All rights reserved.<nl><nl>2015-10-12 17:50:00.48
Submit an article or tip