ZwePyae PhyoOo

ZwePyae PhyoOo

  • NA
  • 1
  • 739

SQL server log shipping error when copying secondary server

Sep 1 2016 7:02 AM
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. :) 

Answers (2)