Hi Robert,

Thanks for the reply . Please find these results

When i am trying to access the Shared Folder on the Primary Server from the Secondary Server, it is not asking for any password but it is still opening the shared folder(Primary Server).

I did check if there are any stored password and there is none.But thats strange.i checked if the shared folder is showing up in "net use" and it is not showing up.I also restarted the secondary server and i am still able to access the shared folder.

The servername is without the FQDN.

select @@servername on Primary Server produces the following result.

KDatabase01\instance

select @@servername on Secondary Server produces the following result

PortalDatabase\instance

When doing logshipping i did not specify FQDN.

Just one thing Robert.

On 10th of February, when i started the Log Shipping and initially ran the BackupDatabase,it ran that. When i did the Copy Database initially i got an error message about Access Denied Error 5.then what i did was changed the log on properties for the SQL Server Agent so that a local user created on the secondary server could run the sql server agent.I ran the copy database again and the transcation file got copied from the primary server to the secondary server. But then only i remembered that i was playing on the live database so i deleted the settings for log shipping.Since then it has not worked.

Now i am wondering why did i delete it 🙁

Well i have been going through this all week.I have typed the first half of the mail in the morning and have been working with this to get this round up and working.Guess what....

now it is working.

Changes that i have made.

In the copy and restore jobs, the servername was referring as KDatabase01\InstanceName in the sqllogship.exe command but it should be KDatabase01. Changed the server name to match that.Did the same for Restore Job also.Ran both the jobs and i am able to see the change happening in the secondary database.

Thanks Robert for your help.

I have setup the replication to happen every 30 min and am monitoring it for 1 day. Will keep you updated Robert.

Thanks