I need help figuring out why log shipping is not working for me. The DB gets created and nothing obviously fails, but nothing past the initial DB-creation ever happens.
Executing this query on Server2 (the log shippee, the server who should be restoring TRN files from Server1):
>select * from msdb.dbo.restorehistory
yields a single record...and that single record is the initial DB restore that's performed to create the log-shipping target DB.
On Server1 (the log shipper), the TRN files do successfully continue to pile up.
On Server2, its "target" folder never ever receives any TRN files at all.
I need help getting this working. Oh, by the way, Server2 is doing NOTHING, there are no DBs on it other than this one I'm trying to create and log-ship to from Server1.
I'm going to put some screenshots below, showing my current settings.