SQL server log shipping error when copying secondary server

ZwePyae PhyoOo

Sep 1 2016 7:02 AM

284

Dear friends,

I have a problem with log shipping of sql server 2005 to sql server 2008

in one computer and not using two computers. Primary Server(2005) shared folder is 'C:\Primary' and I allowed this folder to Full Access of Administrator. Secondary Server(2008) folder is 'C:\Secondary' and I also allowed Full Access to it but not shared. Then I created database on Primary Server with full recovery mode and restore it on Secondary Server.

After it, I setting up log shipping and start job on Server Agent. The problem is started. Backup process of primary server is success but coping it were failed. I don't know why? Please reply me, if you have free time.

I also want to know does schedule backup of log shipping backup the whole database or only new transaction?

Thank you very much to you all for reading my problem. :)