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

David Duff gravatar image

David Duff
11 1 1 1

(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

venkatreddy gravatar image

562 28 29 32

(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

KenJ gravatar image

20.3k 1 4 12

(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

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

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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: 1131 times

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