I have configured two 2003 servers, each with SQL Server 2005 and configured them for log shipping through the wizard. I was able to get the jobs loaded on the secondary server, but the jobs are not showing up under sql server agent jobs on the primary server, thus, the log shipping is not working. When I run the wizard the first time it does connect to the secondary server and it does save the configurations w/out error. Anything I should look for? Thanks for any help?
Answer by venkatreddy ·
Follow the steps below
1)Make sure that SQL server agents running in both the machines.
2)Create a folder(should be network shared) on primary server to hold the scheduled backups of primary database.
2)Create a backup job run on primary server which takes transaction log backup according to schedule.
3)Create a copy job,and executed on secondary server which copies the transaction log files from network shared folder(primary server folder) into secondary server folder(need to be create)
4)Create a restore job executed on secondary server which will apply the copied transaction log backup's to the secondary database.
you can have a monitor server to monitor the log shipping for better performence..