Solved

SQL Server 2005 -- logshipping -- not restore

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

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

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

628 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