Log Shipping

• lkennedy76

  SSChampion

  Points: 13683

  More actions

  October 20, 2009 at 10:51 am

  #156337

  My jobs are not cpoying over the trn file, so I have to manually run the LSCopy job then the LSRestore job and then everything is okay. But why will it not copy? I have check my creds by copying over a text file by running this at the cmd prompt

  runas /user:username cmd

  Password: 123456

  Takes me to C:\windows\system32\xcopy \\192.168.1.1.0\translogs\test.txt \\192.168.0.0.2\translogs\test.txt

  So I dont think it's a permission issue, any ideas?

  MCSE SQL Server 2012\2014\2016

• lkennedy76

  SSChampion

  Points: 13683

  More actions

  October 21, 2009 at 8:10 am

  #1068886

  Anybody have any ideas?

  I removed log shipping and put it back in place noe will it not copy over the *.trn file but now if I set off the LSCopy job maually it fails

  Executed as user: Server\username. The step failed.

  Really need some help here guys!

  MCSE SQL Server 2012\2014\2016

• lkennedy76

  SSChampion

  Points: 13683

  More actions

  October 21, 2009 at 9:41 am

  #1068960

  Thanks, I figured it out and I am using Red Gate! Good Luck if you ever have an issue!

  MCSE SQL Server 2012\2014\2016