November 25, 2013 at 2:33 am
Hi All,
Since couple of days i am experiencing on issue regarding log shipping restoring.
backup and copy jobs are running successfully and trl file are moving from backup shared folder to subscriber restoring folder. when i see the restore job history , i did not find any failures. but trl backups are not restoring into subscription db. i did not find any errors related to restoring job failures and even i given full control on restoring shared folder to subscriber sqlserver agent. kindly help me to fix the issue.
Regards,
Shenkar Gade
November 25, 2013 at 3:08 am
This link will help you http://www.mssqltips.com/sqlservertip/2553/different-ways-to-monitor-log-shipping-for-sql-server-databases/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 25, 2013 at 6:33 am
Thanks Bhuvnesh,
given link is help full to monitor the log-shipping.:-)
but .. i did not found any error related regarding restoring job... still history is showing success even trls are not applying to subscription database.
November 25, 2013 at 7:07 am
if the history of the job shows it is succeeding it probably means there are no logs for it to restore, which suggests a missing log file.
run these queries to see what is going on, you may have to reinitialise the logshipping from a fresh full backup
-- error details
select * from msdb.dbo.log_shipping_monitor_error_detail
select log_time_utc,message from msdb.dbo.log_shipping_monitor_error_detail
-- tells you last log copied and restored, primary and secondary server names
select * from msdb.dbo.log_shipping_monitor_secondary
---------------------------------------------------------------------
November 26, 2013 at 12:24 pm
Hi Gorge,
surprised , now I am finding below error even after reconfigured log shipping by dropping existing subscriber database.
Msg 14412, Level 16, State 1, Line 1
The destination database is already part of a log shipping plan.
Regards,
Shenkar Gade
November 27, 2013 at 3:40 am
Are you trying to recreate the logshipping jobs without removing the logshipping setup first? If so that explains your error, dropping the destination database is not enough.
You do not need to remove logshipping, just pause the copy,load and restore jobs, take a full backup and restore it to the destination with norecovery, then re-enable your jobs. Do one cycle to check it works.
---------------------------------------------------------------------
November 28, 2013 at 6:41 am
Hi George,
perfect,.. it is working fine now .. thanks alot
November 28, 2013 at 7:13 am
no problem
---------------------------------------------------------------------
November 28, 2013 at 9:57 am
Hi All,
I have restore Problem in Log Shipping, the copy job succeed but when i see the restore job status that time it showing restore succeed but no data is reflecting in secondary server, when i see the restore job history it was showing this message: Searching through log backup files for first log backup to restore secondary database. the secondary database could not found the log backup file. that could be applied to secondary database
please help me
Thanks & Regards
Chalapathi pagidakula
November 28, 2013 at 10:03 am
you should start your own thread please for future queries.
you have the same problem as shenkar, a transaction log backup is missing. If you cannot find it and apply it manually re-initialise logshipping as described above.
---------------------------------------------------------------------
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply