Log Shipping Backup Failure..

• jblovesthegym

  Ten Centuries

  Points: 1048

  More actions

  May 15, 2012 at 4:51 am

  #98464

  I should really say "Restore failure", but anyway...

  Here's the Event Log chain...

  The backup data in '\\OurServerName\T$\LOG_RESTORE\XXXXXXXXXX_tlog_201205141815.TRN' is incorrectly formatted.

  Backups cannot be appended, but existing backup sets may still be usable.

  Error: 644, Severity: 21, State: 5

  Could not find the index entry for RID '362d2b9b000200000100100002000000' in index page (1:5496937), index ID 12,

  database 'XXXXXXXXXXXXXXXX'..

  Error: 3314, Severity: 21, State: 3

  Error while undoing logged operation in database 'XXXXXXXXXXXXXXXX'. Error at log record ID (294398:764:9)..

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  May 15, 2012 at 12:00 pm

  #1487919

  That error usually means that that TRN file is corrupt.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]