Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Logshipping restore job failed Expand / Collapse
Author
Message
Posted Monday, September 17, 2012 10:10 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 20, 2014 9:58 AM
Points: 37, Visits: 159
Hi Experts,

In one of my prod server I have configured logshipping for two databases in a single server (SQL Server 2005 Standard edition 32bit on Windows 2003 server) but there was a problem with one of them, one database is getting logged up by logshipping to the secondary server and getting restored but the second database is getting failed in restoring the logs, I couldn’t find any error as it simply says the restore job couldn’t be done. I have configured two diff shared folders for both the database and gave same permissions for both of them. When one database logs can get restored why can’t the other.

Please let me know where I went wrong.
Post #1360544
Posted Wednesday, September 19, 2012 8:03 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 8:53 AM
Points: 4,350, Visits: 6,162
We cannot help you with so little information. What is the EXACT, DETAILED error message the job that is failing gives?

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1361375
Posted Wednesday, September 19, 2012 10:53 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 18, 2014 8:25 AM
Points: 1,519, Visits: 2,550
..Did someone backup the log and broke the LSN by any chance for the DB that's failing ?
Or..
anyone deleted any of the log backup from the directory ?

As Kevin mentioned, we need exact error message to help..
Post #1361731
Posted Friday, September 21, 2012 1:39 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 20, 2014 9:58 AM
Points: 37, Visits: 159
Hi All,

Thank you for the reply, I have configured the logshipping on this database and from starting the log's are not getting restored to the destination database from the copied folder. i am not getting any error but when i see, the logs were not restored in to the secondary database.

I dpont know where i went wrong please let me know..
Post #1362462
Posted Friday, September 21, 2012 1:45 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, December 14, 2012 2:23 AM
Points: 244, Visits: 409
if copy the statement in restorelog job to a query window and execute you may get detailed information.

Regards,
MShenel
Post #1362464
Posted Friday, September 21, 2012 2:04 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:57 AM
Points: 6,304, Visits: 13,601
ksr39 (9/21/2012)
Hi All,

Thank you for the reply, I have configured the logshipping on this database and from starting the log's are not getting restored to the destination database from the copied folder. i am not getting any error but when i see, the logs were not restored in to the secondary database.

I dpont know where i went wrong please let me know..

Check the history carefully for the restore job for error messages. My guess is you have log backups occurring on the database outside of the log shipping backup job.

Depending on your full backup regime, you can synchronise the 2 databases by taking a differential backup from the primary and restore it to the secondary.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1362475
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse