locked
Mirroring failed on secondary: . SQL Server cannot process this media family. RRS feed

  • Question

  • We are receiving error on one of mirror database. We have 6-7 databases configured for mirroring. But, somehow this issue occurs on only 1 database. Both SQL server has same SQL version and service pack. Any help would be greatly appreciated.

    2019-02-08 11:30:20.52  *** Error: An error occurred during the restore operation for secondary database 'ABC.(Microsoft.SqlServer.Management.LogShipping) ***

    2019-02-08 11:30:20.52  *** Error: The media family on device 'T:\ABC _20181229110142.trn' is incorrectly formed. SQL Server cannot process this media family.

    RESTORE LOG is terminating abnormally.(.Net SqlClient Data Provider) ***

    2019-02-08 11:30:20.54  Deleting old log backup files. Primary Database: ABC

    2019-02-08 11:30:20.78  The restore operation completed with errors. Secondary ID: 'e3747cc1-3f70-4434-b044-96c9e5d4a304'

    2019-02-08 11:30:20.79  ----- END OF TRANSACTION LOG RESTORE     -----

    Friday, February 8, 2019 4:40 PM

Answers

  • You will need to reinit database mirroring on that database to get it back in sync.

    • Marked as answer by Chickoo79 Monday, February 11, 2019 6:39 PM
    Monday, February 11, 2019 4:57 PM

All replies

  • Hi, has log shipping for this one database ever worked, or, has it failed every time the process ran and never completed successfully?
    • Edited by rvsc48 Friday, February 8, 2019 6:30 PM changed term
    Friday, February 8, 2019 6:25 PM
  • The backup file is likely corrupt.

    Friday, February 8, 2019 6:25 PM
  • Hello Tom,

    I have checked from last full backup and it seems there is no corrupt backup. IsDamaged = 0 

    Friday, February 8, 2019 7:09 PM
  • The last full might be fine.  The problem is with the specific file T:\ABC _20181229110142.trn
    Monday, February 11, 2019 12:06 PM
  • The last full might be fine.  The problem is with the specific file T:\ABC _20181229110142.trn
    How can i resolve that? Do i need to remove the database from log shipping and add again?
    Monday, February 11, 2019 3:18 PM
  • You will need to reinit database mirroring on that database to get it back in sync.

    • Marked as answer by Chickoo79 Monday, February 11, 2019 6:39 PM
    Monday, February 11, 2019 4:57 PM