Created a transaction log shipping configuration between two SQL Servers (different VMs) using the built in wizard. Backup job runs on primary server, copy and restore jobs run on secondary server.
The restore job fails giving the following message (message is in job history):
Error: The restore operation cannot proceed because the secondary database 'My_DB_Name' is not in NORECOVERY/STANDBY mode.(Microsoft.SqlServer.Management.LogShipping)
Under my secondary database Properties > Options, I see recovery model is set to Full. What do I need to do to make the restore job run?