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

Problem in Log Shipping Expand / Collapse
Author
Message
Posted Monday, July 30, 2012 9:00 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 13, 2014 3:33 PM
Points: 179, Visits: 726
we have Setup Log shipping in SQL SERVER 2008 environment.Today we faced with a problem in our secondary database.Every time that the Copy and Restore jobs ran,it took longer than the previous time.For the Copy process,It seems ,It always copies all the transaction log backups from a specific time again and again and for restore job,it try to restore all the log from a specific date .Also,it seems that Last_restored_date , Last_Resore_file,Last_copied_date and Las_Copied_File are not being updated.I would apprciate if someone help me on this
Post #1337639
Posted Tuesday, July 31, 2012 3:11 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:51 AM
Points: 5,958, Visits: 12,839
check and post any history from the copy and restore jobs on the secondary server.

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1337742
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse