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

In Logshipping, Restore job is using the full backup and restoring every time and not taking the t-logs Expand / Collapse
Author
Message
Posted Friday, June 7, 2013 4:52 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 6:43 AM
Points: 13, Visits: 111
hi experts,
I have two servers, one is primary and another is secondary. i have created backup and copy job at primary and restore job at secondary on may 27, 2012.
these jobs are running 5 days successfully, but restore job every time taking may 27th full backup and then restore it, what is the reason.

If this is answered already in the forums, plz send me the link. thanks and I appreciate everyone for their work.
Post #1461026
Posted Friday, June 7, 2013 5:17 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 1:53 AM
Points: 591, Visits: 1,332
Hi,
as per your post it seems back and copy are in primary
and restore is in secondary

in log-shipping

ls_backup job will be in primary and
ls_copy ,ls_restore jobs will be in secondary

verify this first and you are saying every time it is taking may 27 for restore

1. first check the configuration of log-shipping like paths every thing is correct
2. go to the secondary and check any errors
3. try to run the ls_backup job in primary
4. try to run the ls_copy and ls_restore jobs in secondary
verify whether all jobs run success
if success your log- shipping will be in sycn at both ends

5 if not try to check all logs in primary and secondary are in sequence if not from the time it is missing logs copy to secondary and try to run all jobs at both end then it will be ok

6. OR or take a differential backup in primary and copy in secondary and restore with standby read/only and all log will be applied and run the jobs in Primary and secondary

check the logshipping status and sync is ok or not !!!


Thanks
Naga.Rohitkumar
Post #1461034
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse