June 22, 2011 at 7:16 am
Hi Guys,
I have configured logshipping successfully on sql server 2005 sp4 servers.everything is good but today when i am opened the
LOGSHIPPING STATUS REPORTS its showing alert error.but all jobs are showing successfully.backup job and copy is working both fine.but restore job is report is
2011-06-22 18:30:15.46Skipped log backup file. Secondary DB: 'database', File: '\\drpcjobs\databaseCOPY\database_20110622125013.trn'
2011-06-22 18:30:15.46Could not find a log backup file that could be applied to secondary database 'database'.
there no restoration is going .
please give me the suggestions.
Regards
venkat
June 22, 2011 at 8:52 am
Personally i'd reconfigure for that DB and start again. Although somebody may post a solution that won't require that?
June 22, 2011 at 9:43 am
maybe one of the trn files are (not copied/deleted) and so it keep on searching for that file as it cant apply other files...
Reapplying log shipping on tht db should be last option.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
June 22, 2011 at 9:55 am
That was my initial thought, but then he says the COPY job has run successfully. So either the file is not there (possible to copy manually [if exists] - depending on retention period etc), or the file IS there but not restorable (in which case, I'd still suggest reconfigure)
June 22, 2011 at 9:58 pm
SKYBVI (6/22/2011)
maybe one of the trn files are (not copied/deleted) and so it keep on searching for that file as it cant apply other files...Reapplying log shipping on tht db should be last option.
Regards,
Sushant
Thank you for reply guys.I have configured three times and faced same .But finallly i configured again and done successfullly.
Thank you guys bye
Regards
venkat
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply