March 23, 2015 at 11:02 pm
HI Experts,
Please help me here,
WE have production SQL server 2008 R2 having database MicrosoftDynamicsAX database, on which I have tried to configure log shipping twice. but failed twice,
Upon configuration, The backup job on Primary Runs fine every 15 mins
On secondary, the Copy job, copy log files from primary to secondary share folder,
all share folders have full access permissions
Error at The back job, which will search through the secondary share and SKIPS EACH T-LOG BACKUP, in history details its written, searching through folder , skips each ..trn files, could not find log file that can be applied to database and say backup job successful,
After hour or so, the monitor start throwing red alerts, back up job has thresh hold of 45 minutes, and has not performed restore since 137 minutes etc. :crying:
when I inspect the full backup LSN number and that of LSN of T-log generated upon Log shipping configuration, there is mismatch.
I CHECKED OTHER JOBS RUNNING ON PRODUCTION SERVER, ONLY TWO JOBS RUNNING "Performance iNDEX Stats" HOURLY BASIS, && CAPTURE STATS ON MicrosoftDynamicsAX database.
Please refer attached Full backup, T-log back generated and other stats jobs running snaps,
Kindly help me, I am unable to trace the root cause why, Log shipping is fails,
APpricitae your replies
March 31, 2015 at 2:07 am
After you set up the log shipping any restore took place on secondary server? What is the recovery model of database?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply