I don't know what I am missing, but Log shipping is working between instances in the same server, but it is not working between 2 different servers.
Little explanation of what I did
I configured log shipping for one of the DB and followed all the guidelines and got it to work. The Step I took before configuring the log shipping was that I took the backup of the DB on the primary server and restored it on the secondary server. Then I created a “Test table” in the DB on the Primary server just to test if the log shipping would work or not. When all 3 jobs ran successfully (Log backup job, copy job and restore job), I was not able to see the Test table in the DB on the secondary server. When I looked at the job history, all the steps were taken and the history had no errors, but still missing data on the secondary server (didn’t see Test table on the secondary database).
So, this is what I did after that. I configured log shipping on the same server but between 2 different instances and got it to work. However, this time when I created a “Test table” in the DB, the log shipping worked and I was able to see changes on the secondary database.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]