?
Solved

SQL Server 2005 -- logshipping -- not restore

Posted on 2014-09-08
1
Medium Priority
?
148 Views
Last Modified: 2014-11-04
Hello,
  I setup log shipping for  a DB. The logs are generated and copied . However, in the SSMS, I notice that no logs are applied.
This is the message I see in the viewer
Skipped log backup file. Secondary DB: 'docnumdb', File: 'F:\logshipping\Other\\docnumdb\docnumdb_20140909013558.trn'
2014-09-08 21:37:08.22      Could not find a log backup file that could be applied to secondary database 'docnumdb'.

This is a fresh Log Shipping setup. The previous setup was deleted
Thanks for your help
0
Comment
Question by:SiemensSEN
[X]
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
1 Comment
 
LVL 43

Accepted Solution

by:
Eugene Z earned 2000 total points
ID: 40316576
check if you logship set by using UNC path visible and accessible by secondary server
and insure that you do not have an another trans log backup  for the same  DB

BTW: check 3rd party backup apps: e,g. Idera sqlsafe  has ability t5o set logshipping without copy translog files using the same set  location for backups and restores
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

719 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