question

David Duff avatar image
David Duff asked

SQL Server 2005 Log Shipping

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?

log-shipping
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

venkatreddy avatar image
venkatreddy answered

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

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image
KenJ answered

This may be too simple, but is the SQL Agent in the running state on the primary server?

The wizard will happily create the secondary database and the jobs on both servers, but they won't show up or execute unless the agent is running.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Basit avatar image
Basit answered

Firstly you check that the SQL server Agent is working fine and log in with the Account that you have login the machine

Then create a folder 3 folder that must be access from Both Secondry and primary server..

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.