Log Shipping configuration

• MTY-1082557

  SSCarpal Tunnel

  Points: 4540

  More actions

  July 13, 2010 at 2:29 pm

  #226731

  I had a log shipping set and working perfectly. Until I back from vacation the IT department moved the backup directory to another server. This made my log shipping not restoring anymore. I re-configured the options but the file don’t restore at all.

  I ended deleting everything since other IT changes were made. I tried to configure my log shipping again and it “works” but the Restore job doesn’t restore anything. It doesn’t pick up the file.

  Any advice?

• SkyBVI

  SSCoach

  Points: 15128

  More actions

  July 13, 2010 at 3:39 pm

  #1192375

  Hi,

  What do you mean by " log shipping “works” but the Restore job doesn’t restore anything. It doesn’t pick up the file."

  how can then log shipping work. Is your database restoring on secondary server??

  Check all the backup files and the restoring locations mentioned in the log shipping configuration.

  Have you corrrectly mentioned hte copy,restore,alert timings in the configuration as

  compared to earlier log shipping configuration..

  It would be better that you reconfigure log shipping carefully again.

  Sushant

  DBA

  Virgin Islands

  Regards
  Sushant Kumar
  MCTS,MCP

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  July 13, 2010 at 5:21 pm

  #1192419

  Hi MTY,

  Please try to provide full information. If you are getting any error please post it.

  Thanks & Best Regards,

  SQLBuddy