i have a sql 2005 db with log shipping enabled.
the secondary server is suddenly giving me the below errors, anyone any tips on how to fix the issue trans log? or am i going to have to do a full db restore?
Error: Could not apply log backup file
Error: Could not redo log record
Restore from a backup of the database, or repair the database.
An error occurred while processing the log for database 'SysproCompanyW'. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.
RESTORE LOG is terminating abnormally.
Processed 0 pages for database 'SysproComp