Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2008-10-15
7
Medium Priority
?
208 Views
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....



0
Comment
Question by:fahVB
  • 5
  • 2
7 Comments
 
LVL 60

Expert Comment

by:chapmandew
ID: 22721245
are you sure it is being restored?
0
 

Author Comment

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

Expert Comment

by:chapmandew
ID: 22721386
do you have the exact error message?
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 

Author Comment

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


logshipping.jpg
0
 

Author Comment

by:fahVB
ID: 22721777
I am seeing this error in sql logs

Error: 14420 Severity: 16, state:1
0
 

Author Comment

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

0
 

Accepted Solution

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

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Ready to get certified? Check out some courses that help you prepare for third-party exams.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

581 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