Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chetan_dba
Starting Member
21 Posts |
 Posted - 2008-04-03 : 03:46:40
|
| Hi This is chetan jain sql server DBA.I came accross a probplem while synchronising production with DR in logshipping.logshipping was stopped and the message was " Cannot copy the ......TRN . file is corrupted.can anybody suggest that what should be done if TRN file is corrupted...because if i manully restore the logs at DR i will need every log file to sync Prod with Dr.log file that is corrupted cannot be skipped...neither it can be restored at Dr.please suggest the solution..Thanks in Advance...Thanks in advance.-- Chetan |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-03 : 23:22:56
|
| Tried copy that file manually? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-03 : 23:25:56
|
| If the TRN file is indeed corrupted (should test by restoring full backup and then tlog backup chain on the primary server), then you'll need to rebuild log shipping.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
chetan_dba
Starting Member
21 Posts |
Posted - 2008-04-04 : 01:49:44
|
| I can do the backup of Prod and then load the same on DR.But is there any way to recover the corrupted transaction log backup file.Thanks in advance.-- Chetan |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-05 : 23:50:37
|
| You don't need that old corrupted log backup after restoring from new full backup. |
|
|
|
|
|
|
backup log file corrupted