n00bDBA (8/7/2012)

---

Hi,

Trying to work with log shipping. Primary server is backup log files but the secondary isn't copying them to the secondary server. The failed job in secondary (LSCopy..) doesnt tell me anything useful.

I have the following setup:

Both primary and secondary use the same AD account for ALL services.
The AD account has full control for both the Backup location for the Log file and the Copy/Read location on the Secondary.

I used the script out button so I have that to look at, but i cant see anything wrong (Not suprising not sure what im looking at!)

Ive ran the default Log Shipping Report on both the Primary and Secondary.

On the Primary it shows the Primary being in a Good Status. The seconary shows up but has no details against it apart from that.

On the Secondary it only shows a test db i tried to see if i could Log shipping working. (This worked. So i deleted the Agent jobs and deleted the db should i have done more?)

Ive been going though the MS 2008 high availability book to set it up but its troubleshooting section is weak to say that least.. Everything says this is the easest method.. so feeling a bit disappointed at the moment

Hope someone can help.

// EDIT

Not sure if it helps but, I set up a monitor server when i created the Log shipping.

The Log_shipping_monitor_history_detail table only has info again on the Primary Agent.. nothing on the secondary.

Talking about removing.. Looking at BOL it says you just need to use the GUI and clear the Log Shipping tick box. When i do that. The jobs are not removed from the secondary server.. Is there anything else i should do on the secondary when removing log shipping..

exec sp_help_log_shipping_primary_database
@database = 'primary_database'

exec sp_help_log_shipping_secondary_database
@secondary_database = 'secondary_database'