Advertisement

11.13.2007 at 02:13AM PST, ID: 22956683
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!
9.2

problem with delay in log shipping

Asked by sharscho in MS SQL Server

Tags: , ,

Log shipping problem, I have an issue with the logshipping between 2 prd servers during the backup job of the primary server. The backup starts at 20:00 and one hour later we start getting alerts that the logshipping is delayed. After it send the first alert, it sends one after 15 min then after 5 min and again after 2 min. Then it send a full report that the db has not backed up for 67 min. After this alert and completion of the backup no more alerts are being send. I see on both servers the same backup transaction logs and the datafiles of the secondary standby server have also current dates which I asume that the logs are being applied just fine.
Some facts: The log are located on a different disk than the data and backupfiles.
This is a db of 69G and the backup job contains a step for compressing the file after the completion of the backup. This whole backup/compress process takes 1:15. approximately the same time the logshipping problems lasts.
I want to know if someone has any idea why this happens like this and how to prevent it. Can it be that the server is not good enough to handle the backup process together with the log shipping? And or can the logshipping be put on hold during the backup, is that wise? Can the alert job be delayed for during the backup? I would like some idea on how I can stop the log shipping delay.

A sample of what is in the first alert mail.
Error: 14420
Severity: 16
Date: 20071112
Time: 214602
Database: msdb
Message: Error: 14420, Severity: 16, State: 1 The log shipping source Sqlserver_prd\ALMPRD.Impact has not backed up for 61 minutes.
Check the Sqlserver_prd\ALMPRD SQL Server ErrorLog and the Application event log on the server for additional details

After that these ones follows with different time stamps and delay duration.
Log Shipping Alert Job - Backup Log Shipping Alert - Backup Run date/time - 20071112/21:46:01 Run duration in hours:minutes:seconds - 00:00:00 Executed as user: Sqlserver_prd\SQLAdmin. The log shipping source Sqlserver_prd\ALMPRD.Impact has not backed up for 61 minutes. [SQLSTATE 42000] (Error 14420).  The step failed.Start Free Trial
 
Keywords: problem with delay in log shipping
Title
1 log shipping failure
2 Duration of media with out opening it.
3 Errorlog table
4 Shipping
5 Restore job failing on secondary serve…
6 Create smtp delivery delay
 
Loading Advertisement...
 
[+][-]11.13.2007 at 03:38AM PST, ID: 20270764

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 30-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]11.13.2007 at 07:46AM PST, ID: 20272276

View this solution now by starting your 30-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL Server
Tags: log, shipping, delay
Sign Up Now!
Solution Provided By: EugeneZ
Participating Experts: 2
Solution Grade: A
 
 
[+][-]11.13.2007 at 07:48AM PST, ID: 20272290

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 30-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]11.14.2007 at 05:41AM PST, ID: 20279694

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20081112-EE-VQP-44 / EE_QW_2_20070628