SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Logshipping restore job failed


Logshipping restore job failed

Author
Message
ksr39
ksr39
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 Visits: 200
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.
TheSQLGuru
TheSQLGuru
SSC-Dedicated
SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)

Group: General Forum Members
Points: 31559 Visits: 8671
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 on googles mail service
Joy Smith San
Joy Smith San
SSCertifiable
SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)

Group: General Forum Members
Points: 6284 Visits: 3200
..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..
ksr39
ksr39
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 Visits: 200
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..
shen-dest
shen-dest
Mr or Mrs. 500
Mr or Mrs. 500 (556 reputation)Mr or Mrs. 500 (556 reputation)Mr or Mrs. 500 (556 reputation)Mr or Mrs. 500 (556 reputation)Mr or Mrs. 500 (556 reputation)Mr or Mrs. 500 (556 reputation)Mr or Mrs. 500 (556 reputation)Mr or Mrs. 500 (556 reputation)

Group: General Forum Members
Points: 556 Visits: 409
if copy the statement in restorelog job to a query window and execute you may get detailed information.

Regards,
MShenel
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)

Group: General Forum Members
Points: 52747 Visits: 17672
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" ;-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search