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 issue with restoring job Expand / Collapse
Author
Message
Posted Monday, November 25, 2013 2:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 08, 2014 3:04 PM
Points: 6, Visits: 28
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
Post #1517179
Posted Monday, November 25, 2013 3:08 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:19 AM
Points: 2,820, Visits: 3,916
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
Post #1517184
Posted Monday, November 25, 2013 6:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 08, 2014 3:04 PM
Points: 6, Visits: 28
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.




Post #1517223
Posted Monday, November 25, 2013 7:07 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:46 PM
Points: 5,849, Visits: 12,585
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


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

Post #1517243
Posted Tuesday, November 26, 2013 12:24 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 08, 2014 3:04 PM
Points: 6, Visits: 28
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
Post #1517797
Posted Wednesday, November 27, 2013 3:40 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:46 PM
Points: 5,849, Visits: 12,585
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.


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

Post #1517977
Posted Thursday, November 28, 2013 6:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 08, 2014 3:04 PM
Points: 6, Visits: 28
Hi George,

perfect,.. it is working fine now .. thanks alot
Post #1518343
Posted Thursday, November 28, 2013 7:13 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:46 PM
Points: 5,849, Visits: 12,585
no problem

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

Post #1518356
Posted Thursday, November 28, 2013 9:57 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 9:13 AM
Points: 34, Visits: 27
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

Post #1518385
Posted Thursday, November 28, 2013 10:03 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:46 PM
Points: 5,849, Visits: 12,585
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.


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

Post #1518387
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse