Solved

SQL Server 2005 -- logshipping -- not restore

Posted on 2014-09-08
1
127 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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.

706 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

18 Experts available now in Live!

Get 1:1 Help Now