SQL error --Logshipping

Posted on 2011-05-09
Last Modified: 2012-05-11
  I set log shipping and it been working great for a few month. However, starting last week I notice that there  is an issue and no logs are been applied.

Can I fix this issue or do I have redo the logshipping..

The last log applied is admin_db_201105061211511.trn

SQL Server 2005

The error I get is :

The backup data at the end of "f:\logshipping\qcsiteadmin_db\admin_db_20110506130011.trn" is
incorrectly formatted. Backup sets on the media might be damaged and unusable.
To determine the backup sets on the media, use RESTORE HEADERONLY. To determine the usability of the backup sets,
 run RESTORE VERIFYONLY. If all of the backup sets are incomplete,
reformat the media using BACKUP WITH FORMAT,
which destroys all the backup sets.

Question by:SiemensSEN
    LVL 20

    Accepted Solution

    What does:
    Restore Verifyonly "f:\logshipping\qcsiteadmin_db\admin_db_20110506130011.trn"
    give for result?

    Have you changed the filegroups (added one for instance), this can be checked with:
    RESTORE HEADERONLY "f:\logshipping\qcsiteadmin_db\admin_db_20110506130011.trn"

    Is the size of the backupmedia to big for the filesystem? can it be on a fat32 volume and bigger than 4GB?

    What does the log on the logshipping source say. Examine errorlog on that sql instance!

    Come back with your findings and well figure this out!


    Author Closing Comment

    Sorry, I had to redo the log shipping because this file got deleted in error.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
    Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    779 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

    13 Experts available now in Live!

    Get 1:1 Help Now