Log Shipping on MS SQL 2005

Posted on 2011-10-31
Last Modified: 2012-05-12
Hi Experts,

I'm running Log Shipping between two servers and I see all the .trn files getting moved from primary server to secondary server. However it's failing to apply the logs at secondary server. The message from Log Shipping restore log job step states "Skipped log backup file. Secondary DB".

Is there anything I'm missing, any help will be greatly appreciated.



Question by:Samoin
    LVL 10

    Accepted Solution

    LVL 1

    Author Comment

    I'm pretty positive that permissions are good on both the primary and secondary servers.

    Can we manually update a single log? Do you the script or steps to manually restore a single log to see if everything works fine or not.

    LVL 25

    Expert Comment

    This also happens when the log files to be applied are quite old and the latest data is there in the secondary database. Check for the last applied log on the secondary database and the one it is applying.

    Are you deleting the already applied log from the log backup repository?

    And does by any chance, someone restored recent differential backup at the secondary server?
    LVL 15

    Expert Comment

    by:Aaron Shilo

    you should check if you have another JOB backing up the LOG file on server A.
    if so then hes breaking the chain and you should delete it.

    you shouldn't have any active process backing up the LOG file but the LOG Shipping process.
    LVL 1

    Author Closing Comment

    Yes, it was related to the security as sqlserver service account on second server was unable to find the files.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Viewers will learn how the fundamental information of how to create a table.

    761 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

    8 Experts available now in Live!

    Get 1:1 Help Now