February 8, 2019 at 9:43 am
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 -----
February 8, 2019 at 10:52 am
EasyBoy - Friday, February 8, 2019 9:43 AMWe 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 -----
Maybe the backup file is corrupt. Try doing a restore headeronly on the file.
RESTORE HEADERONLY
FROM DISK = 'X:\PathToLogFileBackup'
Sue
February 8, 2019 at 12:08 pm
Sue_H - Friday, February 8, 2019 10:52 AMEasyBoy - Friday, February 8, 2019 9:43 AMWe 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 -----
Maybe the backup file is corrupt. Try doing a restore headeronly on the file.
RESTORE HEADERONLY
FROM DISK = 'X:\PathToLogFileBackup'Sue
Hello Sue,
I have checked from last full backup and it seems there is no corrupt backup. IsDamaged = 0
February 8, 2019 at 12:16 pm
EasyBoy - Friday, February 8, 2019 12:08 PMSue_H - Friday, February 8, 2019 10:52 AMEasyBoy - Friday, February 8, 2019 9:43 AMWe 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 -----
Maybe the backup file is corrupt. Try doing a restore headeronly on the file.
RESTORE HEADERONLY
FROM DISK = 'X:\PathToLogFileBackup'Sue
Hello Sue,
I have checked from last full backup and it seems there is no corrupt backup. IsDamaged = 0
You would want to check the log backup file that is throwing the errors though - ABC _20181229110142.trn
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply