SQL server log shipping error when copying secondary server

Question

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. :)

Akshay Phadke · Answer

1 )
Ok the first thing which is a very good practice is that for primary and for secondary server you should always keep the same version of SQL management studio .Its always a good practice . Why ? So that two way syncing is possible as both primary and secondary are having same versions . 2 ) You can also have primary as SQL 2005 and secondary as 2008 but here two way syncing is not possible as it cannot do logshipping from higher version to lower version 3) As you had configured log shipping from SQL server management studion hope you had configured repective FTP's as those trn files are getting Transferred frm one server to another 4) Also make sure when you take backup of your primary server you will restore that backup and trn file in No revovery mode

Bikesh Srivastava · Answer

Hi, try this....best example of dropdown with group http://www.codeproject.com/Articles/15505/ASP-NET-DropDownList-with-OptionGroup-support