SQL LogShipping Monitor Error but db's are getting sync'd up

Posted on 2008-10-15
Last Modified: 2012-05-05
I am using sql2000 enterprise wizard log shipping, it is backing up and on the other side its being restored every 15 minutes. However, when i look at the Log Shipping Monitor status it says that "Backup not occuring", any ideas....

Question by:fahVB
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
LVL 60

Expert Comment

ID: 22721245
are you sure it is being restored?

Author Comment

ID: 22721345
yes, i am monitoring some tables and they are getting updated every 15 minutes....
LVL 60

Expert Comment

ID: 22721386
do you have the exact error message?
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users


Author Comment

ID: 22721674
not really, i have attached the way my log shipping looks....


Author Comment

ID: 22721777
I am seeing this error in sql logs

Error: 14420 Severity: 16, state:1

Author Comment

ID: 23316458
I would like to close this question since the recommedation provided didn't work.....


Accepted Solution

fahVB earned 0 total points
ID: 23316497
it was Permission issue, problem is fixed

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question