I'm using log shipping for the first time. I've got it working between my primary and secondary server, on the secondary server the database is
Restoring... which I understand basically means it is waiting to be activated.
I will run
RESTORE DATABASE MyDatabase WITH RECOVERY to activate it, but then what happens next time the job runs to do log shipping? Will it fail? Should I disable the job manually? Will it overwrite my database and set it back to