Fixed. That's probably where the original issue created. Tested in SSMS and then tried to edit in the website since cut/paste doesn't always format correctly.

My apologies. The formula was incorrect, which wasn't the point of the question. We rarely ask questions on business logic, but on SQL Server. However, this wasn't clear.

Question...

I'd be prepared to script out everything and ready to re-set Log Shipping.

Make sure you have  backups of all logins and linked servers, as well as user dbs.

Ichiro still climbing the charts.

Answer changed and points awarded back.

I don't know why I use dw. Old habit. I'll try to stick to the longer syntax in the future as a better example.