[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


SQL error --Logshipping

Posted on 2011-05-09
Medium Priority
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

Marten Rune earned 1000 total points
ID: 35726096
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

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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based developeā€¦
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Screencast - Getting to Know the Pipeline

867 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