SiemensSEN
asked on
Logshipping --SQLserver2005-- not a valid Microsoft Tape Format backup set
Hello,
I have log shipping running for a while but today I getting the error below. How do I fix this issue.
Message
2011-03-01 09:15:08.18 Starting transaction log restore. Secondary ID: '112ad7af-0593-47b3-9e88-7 2443f75cbc 2'
2011-03-01 09:15:08.19 Retrieving restore settings. Secondary ID: '112ad7af-0593-47b3-9e88-7 2443f75cbc 2'
2011-03-01 09:15:08.19 Retrieved common restore settings. Primary Server: 'GRATWA01', Primary Database: 'osv_projects_hipath8k_v4_ 0_db', Backup Destination Directory: 'F:\logshipping\hipath8k_v 4_0', File Retention Period: 43200 minute(s)
2011-03-01 09:15:08.19 Retrieved database restore settings. Secondary Database: 'osv_projects_hipath8k_v4_ 0_db', Restore Delay: 0, Restore All: True, Restore Mode: Standby, Disconnect Users: True, Last Restored File: F:\logshipping\hipath8k_v4 _0\osv_pro jects_hipa th8k_v4_0_ db_2011022 8190010.tr n, Block Size: Not Specified, Buffer Count: Not Specified, Max Transfer Size: Not Specified
---
2011-03-01 09:15:08.43 *** Error: Could not apply log backup file 'F:\logshipping\hipath8k_v 4_0\osv_pr ojects_hip ath8k_v4_0 _db_201102 28223011.t rn' to secondary database 'osv_projects_hipath8k_v4_ 0_db'.(Mic rosoft.Sql Server.Man agement.Lo gShipping) ***
2011-03-01 09:15:08.43 *** Error: The file on device 'F:\logshipping\hipath8k_v 4_0\osv_pr ojects_hip ath8k_v4_0 _db_201102 28223011.t rn' is not a valid Microsoft Tape Format backup set.
RESTORE LOG is terminating abnormally.(.Net SqlClient Data Provider) ***
I have log shipping running for a while but today I getting the error below. How do I fix this issue.
Message
2011-03-01 09:15:08.18 Starting transaction log restore. Secondary ID: '112ad7af-0593-47b3-9e88-7
2011-03-01 09:15:08.19 Retrieving restore settings. Secondary ID: '112ad7af-0593-47b3-9e88-7
2011-03-01 09:15:08.19 Retrieved common restore settings. Primary Server: 'GRATWA01', Primary Database: 'osv_projects_hipath8k_v4_
2011-03-01 09:15:08.19 Retrieved database restore settings. Secondary Database: 'osv_projects_hipath8k_v4_
---
2011-03-01 09:15:08.43 *** Error: Could not apply log backup file 'F:\logshipping\hipath8k_v
2011-03-01 09:15:08.43 *** Error: The file on device 'F:\logshipping\hipath8k_v
RESTORE LOG is terminating abnormally.(.Net SqlClient Data Provider) ***
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.