July 30, 2012 at 9:00 pm
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
July 31, 2012 at 3:11 am
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" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply