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?

more ▼

asked Feb 24, 2010 at 06:32 PM in Default

avatar image

David Duff
11 1 1 3

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

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

more ▼

answered Mar 18, 2010 at 04:04 PM

avatar image

562 29 31 36

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Feb 25, 2010 at 12:00 AM

avatar image

25k 3 13 20

(comments are locked)
10|1200 characters needed characters left

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

more ▼

answered May 31, 2010 at 05:44 AM

avatar image

82 7 7 7

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Feb 24, 2010 at 06:32 PM

Seen: 1313 times

Last Updated: Feb 24, 2010 at 06:32 PM

Copyright 2018 Redgate Software. Privacy Policy