Log Shipping and moving db's problem

[timscronin]

I seem to encountered an issue when detaching db's that are using log shipping. If I move the .mdf file to a new location and turn on the log shipping it is fine. If I have to move the ldf file to a new location and attach, log shipping is no longer able to restore db to target db. Anyone seen this before

 

[jester777]

Is this SQL7 or 2K?
There are several internal tables used by log shipping, if you have moved the tran log dump sites then you will probably have to change the values in the tables.
Don't forget these values are for directory shares so you may have to remove the old share and create a new share from the new location.

Take a look at the following tables
SQL7 msdb..backup_movement_plans
SQL2K msdb..log_shipping_plans

 

[timscronin]

In this case I did not move the dump files/sites, I moved the ldf file for the database itself. What I have seen so far is that if you move the mdf files it will still work, if you move the ldf files log shipping will start failing.