Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Problem in Log Shipping Expand / Collapse
Posted Monday, July 30, 2012 9:00 PM


Group: General Forum Members
Last Login: Sunday, June 21, 2015 1:45 PM
Points: 186, Visits: 753
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



Group: General Forum Members
Last Login: Today @ 4:19 AM
Points: 7,978, Visits: 16,010
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