Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Log Shipping errors Expand / Collapse
Author
Message
Posted Tuesday, August 7, 2012 6:04 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 9:41 AM
Points: 118, Visits: 439
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..
Post #1341180
Posted Tuesday, August 7, 2012 10:02 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:52 PM
Points: 7,079, Visits: 12,569
How to: Remove a Secondary Database (SQL Server Management Studio) - SQL Server 2008 R2

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1341379
Posted Tuesday, August 7, 2012 2:14 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:08 AM
Points: 6,162, Visits: 13,305
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..

check carefully the job history and post any details in full.

also supply details of the following queries.
Run from the primary

exec sp_help_log_shipping_primary_database
@database = 'primary_database'


Run from the secondary

exec sp_help_log_shipping_secondary_database
@secondary_database = 'secondary_database'



-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1341542
Posted Wednesday, August 8, 2012 8:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 9:41 AM
Points: 118, Visits: 439
Hi guys thanks for the replies...

I ran the scripts.

Primary had details.. But the Secondary was empty... Ive ended up deleting it (thank you for the link) and starting again.. seems to have worked this time!

Is it normal to get this kind of half finished result if you enable log shipping via the GUI? Secondary was over a WAN link but it managed to copy the 15gb dbe fine.. Agent jobs were created but it looks like the SP used to set up the connection didnt work???

Can i also get it confirmed how people like to remove log shipping. Im trying to piece together using BOL a clean method just using T-SQL. since

Thanks for any help and hints :)



Post #1341888
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse