Log Shipping Restore Failed - How do I find out why?

I set up log shipping for a database to fire every 10 mins. All the steps o
n
both servers work the first two times. On the 3rd 10 min interval, the log
bkp is created on the source server and is copied to the destination server.
However, the SQL Agent step, "Log Shipping Restore for
SERVER.APPDB_logshipping" shows failure. The log bkp files are in the
appropriate destination server folder but the restore does not work any more
.
Plus, the event interval on the SQL Agent jobs destination server were
showing every 10 mins but now are showing every 15 mins.
How can I determine what happened and how to fix it?
Picine Karppehd
A newbie to VB.Net,
pretty good with VB6,
Certified with SQLServerEven I was facing the similar issue. Whenever there was huge tlog backups,
restore job in the destination server used to fail. I increased the re-try
attempts by 1 after 1 minute for copy as well as restore job in the
destination server. And it seems to be running fine since.
To do the above, go to the restore job in your destination server,
properties, step, advanced, retry attempts...
HTH
GYK
"Picine Karppehd" wrote:

> I set up log shipping for a database to fire every 10 mins. All the steps
on
> both servers work the first two times. On the 3rd 10 min interval, the lo
g
> bkp is created on the source server and is copied to the destination serve
r.
> However, the SQL Agent step, "Log Shipping Restore for
> SERVER.APPDB_logshipping" shows failure. The log bkp files are in the
> appropriate destination server folder but the restore does not work any mo
re.
> Plus, the event interval on the SQL Agent jobs destination server were
> showing every 10 mins but now are showing every 15 mins.
> How can I determine what happened and how to fix it?
> --
> Picine Karppehd
> A newbie to VB.Net,
> pretty good with VB6,
> Certified with SQLServer|||Picine,
Try restoring the copied log file yourself using Query Analyzer and if
there's an error, what the message is.
Ron
--
Ron Talmage
SQL Server MVP
"Picine Karppehd" <PicineKarppehd@.hotmail.com.(donotspam)> wrote in message
news:2618C571-9B99-4365-94EC-B22927DF46B9@.microsoft.com...
> I set up log shipping for a database to fire every 10 mins. All the steps
on
> both servers work the first two times. On the 3rd 10 min interval, the
log
> bkp is created on the source server and is copied to the destination
server.
> However, the SQL Agent step, "Log Shipping Restore for
> SERVER.APPDB_logshipping" shows failure. The log bkp files are in the
> appropriate destination server folder but the restore does not work any
more.
> Plus, the event interval on the SQL Agent jobs destination server were
> showing every 10 mins but now are showing every 15 mins.
> How can I determine what happened and how to fix it?
> --
> Picine Karppehd
> A newbie to VB.Net,
> pretty good with VB6,
> Certified with SQLServer