Solved

SQL Server 2005 -- logshipping -- not restore

Posted on 2014-09-08
1
132 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
1 Comment
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
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
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

863 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now