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 |
|
steel
Posting Yak Master
107 Posts |
 Posted - 2010-04-28 : 02:52:27
|
| Hi Experts,We are facing an issue at one of our production servers.We are using sql server 2005 + SP3 on windows server 2003 + SP2 .We have configured log shipping from one server to another,it works ok for some time say one day but after that the retsore job fails and we find error in the table log_shipping_monitor_error_detail as The log backup (abc) was verified but could not be applied to database (xyz).on the same server we are having another database,Log shipping is working OK for that DB.Please help .Really thankful to all of you in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2010-04-29 : 02:47:22
|
| Thanks for the reply Tara.Actually there was a job scheduled which was truncating the logs.Really thankful to you... |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
LOG shipping issue