Log Shipping - false alerts, real problem...

Tim Groulx

Hello,

I am setting up log shipping between two SQL servers. Everything in the
setup seems to work fine. The problem I am having is that the "Log
Shipping Alert Job - Backup" job is failing, event though the tlog
backup copy & restore process is working fine. When I look at the
histories of both the backup and copy/restore jobs, they are successful
all the way through, I can make changes to the primary db, and see them
get shipped to the secondary server, so I know log shipping itself is
working. The only job that is failing is the backup alert job.

I have the secondary (destination) server setup as the monitor server.

I read that this issue may occur when the job can't access the log
shipping tables within msdb. I have verified that the account under
which log shipping runs has access to all those tables, and the db
above. The account which runs log shipping and the jobs is the same
domain account under which MSSQLServer service runs.

Here is the error message from the job history -

Executed as user: ROTELLACAPITAL\sqlserver. The log shipping source
ODSQLK02.ROTELLACAPITAL.COM.dbTradePL_LS has not backed up for 1246
minutes. [SQLSTATE 42000] (Error 14420). The step failed.

Any ideas why this might be failing? Any ideas how to fix or work around
it?

Thanks,
TGru

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 23 '05 #1

Subscribe Post Reply

5980

Simon Hayes

"Tim Groulx" <ti****@hotmail.com> wrote in message
news:41**********@127.0.0.1...

Hello,

I am setting up log shipping between two SQL servers. Everything in the
setup seems to work fine. The problem I am having is that the "Log
Shipping Alert Job - Backup" job is failing, event though the tlog
backup copy & restore process is working fine. When I look at the
histories of both the backup and copy/restore jobs, they are successful
all the way through, I can make changes to the primary db, and see them
get shipped to the secondary server, so I know log shipping itself is
working. The only job that is failing is the backup alert job.

I have the secondary (destination) server setup as the monitor server.

I read that this issue may occur when the job can't access the log
shipping tables within msdb. I have verified that the account under
which log shipping runs has access to all those tables, and the db
above. The account which runs log shipping and the jobs is the same
domain account under which MSSQLServer service runs.

Here is the error message from the job history -

Executed as user: ROTELLACAPITAL\sqlserver. The log shipping source
ODSQLK02.ROTELLACAPITAL.COM.dbTradePL_LS has not backed up for 1246
minutes. [SQLSTATE 42000] (Error 14420). The step failed.

Any ideas why this might be failing? Any ideas how to fix or work around
it?

Thanks,
TGru

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You don't mention your version and servicepack, but if you don't have SP3
yet, then this might be relevant:

http://support.microsoft.com/default...b;en-us;810969

Simon

Jul 23 '05 #2

tgru

thanks, I'm running enterprise sp3a.

TGru

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 23 '05 #3

Similar topics

UPS Shipping

by: Mark Hewitt | last post by:

Hi, I have a client who is wanting to compute UPS shipping charges for his orders. I believe it is possible to query a UPS service (well, something online, be it a normal cgi ro real web...

PHP

Log shipping alert job backup problem

by: ^CrAsH^ | last post by:

Hi to all, i've a "problem" with log shipping in sql server 2000 sp3. My log shipping works fine, but the task does not update log_shipping_primaries table on secondary server, and so log shipping...

Microsoft SQL Server

.NET Alerts Compliance Criteria Confusion

by: ryan baldwin | last post by:

Hi, I posted this in the GotDotNet .NET Alerts forum, but that was 3 days ago and still no reply so I'll try my luck here. My apologies if there's a better group to post this question in, but at...

.NET Framework

SQL 2000 log shipping question

by: Jason Huang | last post by:

Hi, In the MS SQL 2000 Server, if the log shipping is set up right, does that mean data in primary server changed will mapped to secondary server later on? Thanks. Jason

Microsoft SQL Server

MS SQL Server 2000 Log Shipping problem

by: InProcess | last post by:

We have successfully implemented Log Shipping between two MS SQL Server 2000 servers (bothe SP3). The problem we are having is two fold: 1) The tran log on the primary server is not being truncated...

Microsoft SQL Server

javascript return true or false

by: rkapur12 | last post by:

In my jsp code I have an image which if someone clicks on that it stores data like "string1" in the hidden field that I have defined on page as: <html:hidden property="selectedOfficeType"...

Javascript

Problem applying return false to a div via addEventListener

by: philjhanna | last post by:

Hi I'm having a problem applying return false to a div via addEventListener. I'm adding this so that I can drag (click-hold-move) over an image. (Its so that I can add zooming to the image)...

Javascript

Send Alerts to web clients?

by: Luis Esteban Valencia | last post by:

Is there a way to send timed alerts to ALL web clients conencted to the IIS server (on a server level)? IF NOT Is there a way to send timed alerts to ALL web clients using a certain .Net web...

ASP.NET

Shipping Matrix Calculations

by: Chris Buckett | last post by:

Hi, I was just wondering if anyone has had any experience in developing a shipping matrix. We are based in the UK, and we need to ship both locally and internationally. Local shipping is...

C# / C Sharp

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice