• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 666
  • Last Modified:

Log Shipping failed

Experts.

I have few log shipping jobs failed the reason is, see error:

 RESTORE LOG is terminating abnormally. [SQLSTATE 42000] (Error 3013)  Cannot open backup device 'X:\abc-logbackup\tlog201010292205.TRN'. Device error or device off-line. See the SQL Server error log for more details. [SQLSTATE 42000] (Error 3201).  The step failed.

I checked standby server, it is running fine. any solution?
Lynn
0
yrcdba7
Asked:
yrcdba7
  • 3
  • 3
  • 2
1 Solution
 
EvilPostItCommented:
Does the file exists? If so try copying the original from the source server.

If that doesnt work you may have to restore a full backup from after that transaction log backup as it may be corrupted.
0
 
GSGDBACommented:
0
 
yrcdba7Author Commented:
I saw this log shipping in standby server related database ( KKdb) status is loading, I guess the database in standby server crushed. I ran those command then refresh database but nothing help.

RESTORE DATABASE KKdb WITH RECOVERY
sp_resetstatus KKdb
DBCC DBRECOVER('KKdb')

any solutione w/o restore db in statndby server?
Lynn
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
GSGDBACommented:
when status is Loading. It means the resotre process is not complete.
Wait till the restores process completes.
0
 
yrcdba7Author Commented:
Thank you GSGDBA, I will try your link. Lynn
0
 
yrcdba7Author Commented:
The standby server is clustering server, so can I do restore db to it?
0
 
GSGDBACommented:
Yes, Restoring Database will not affect your cluster.
You are doing database level changes only.
0
 
EvilPostItCommented:
When transaction log shipping is running, the destination database will always be in a "Restoring" state. Unless you have it in standby mode. Which means that it is still in a restoring state but you can read the data.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now