September 17, 2012 at 10:10 pm
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.
September 19, 2012 at 8:03 am
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
September 19, 2012 at 10:53 pm
..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..
September 21, 2012 at 1:39 am
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..
September 21, 2012 at 1:45 am
if copy the statement in restorelog job to a query window and execute you may get detailed information.
Regards,
MShenel
September 21, 2012 at 2:04 am
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" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply