We help IT Professionals succeed at work.
Get Started

Log Shipping - Working or not working

218 Views
Last Modified: 2015-09-29
Hello there,

I set up Log Shipping and all was working fine till this morning when I queried the secondary db to see if the DB is is sync with the primary Db and it turned out that since 21th Sept, the secondary DB is not getting updated.Under LSAlert job report in primary & secondary server the status shows 'Alert' in red whereas the copy & restore jobs are running properly.Also the share folders, I see all the files with the correct dates. but the secondary db is not in sync. One thing to mention is that the 2 servers time has gone 1 hour back since 22 Sept due to Daylight saving. Could that have messed the log shipping. Now what is the way out to this. Do i need to del the log shipping which I created and again create a new one again.Please help!!!!

cheers
Zolf
Comment
Watch Question
SQL SERVER EXPERT
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 8 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE